Company: Expedia

Difficulty: medium

Problem Statement

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).

More Expedia OA questionsInterview experiences