🎁 Exclusive Offer! Join our
Telegram Channel
to get **special discounts** and updates! 🚀
Question 29 - 100% Working Solution | Buy Now
Description
2 Live
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.