Company: Expedia
Difficulty: medium
An online tax reporting application needs a summary report of account activity. It should list each account's email and the sum of reported amounts during 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).