Company: Expedia_12thjuly
Difficulty: medium
A tax-filing web application needs a summary report of account activity. It should list, for each account, the account's email address together with the total amount reported over the year 2023. The result should have the following columns: email | total_report_amount email - the email address of the account. total_report_amount - the sum of reported amounts submitted in 2023, rounded to two decimal places. The results should be sorted in ascending order by email . Note: Only reports submitted in the year 2023 should be included in the report. Ensure all decimal values are formatted to include trailing zeros if necessary (e.g., 5.00).