🎁 Exclusive Offer! Join our Telegram Channel to get **special discounts** and updates! 🚀

🚀 Struggling with coding interviews? We've got you covered! 💡 Practice real questions, sharpen your skills, and land your dream job! 🎯
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.

Asked in: Amazon

Image of the Question

Question Image

All Testcases Passed ✔



Passcode Image

Solution


Please login to view the solution