2. SQL: Ecommerce Deal Report
An online shop needs a new deal history feature. Create a query that returns a list of the top three seller profiles with the highest total deals in June, 2022.
The result should have the following columns:
first_name / last_name | email | total.
total - the total amount of all deals for a specific profile
The result should be sorted in descending order by total.
The result should be limited to the first three records.
Note:
Only deals for June 2022 should be included in the report.
Asked in: Amazon
Image of the Question
All Testcases Passed ✔
