Company: IBM_16nov
Difficulty: medium
MMORPG User Financial Engagement Report Problem Description In MMORPG gaming, understanding users' financial engagement with different payment models is key to tailoring experiences and offers. The development team is creating a detailed report that showcases each user's engagement as either a prepaid account or as a subscriber. The result should have the following columns: * username - the name of the user * existing_balance - the current prepaid balance of the user, prepended with a dollar sign, $, and with two decimal places, including trailing zeros if necessary, e.g., $500.00 or $0.00 if the user does not have a balance * has_subscription - the derived column that shows either Yes or No that indicates whether the user has an active subscription The results should be sorted in ascending order by username. Schema: users table: * id: INT, PRIMARY KEY, The identifier of the user * username: VARCHAR(255), The name of the user prepaids table: * user_id: INT, FOREIGN KEY(user_id => users