MMORPG User Financial Engagement Report

Problem Statement

MMORPG User Financial Engagement Report 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. Write an SQL query that returns one row per user with the following columns, in this order: username - the name of the user; existing_balance - the current prepaid balance of the user, prepended with a dollar sign $ and with exactly 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 , indicating whether the user has an active subscription. The results should be sorted in ascending order by username . Tables users Column Type Constraints Description id INT PRIMARY KEY The identifier of the user username VARCHAR(255) The name of the user prepaids Col