2 hours ago

Rohit • 20

Hyderabad

Question: Deal History Feature (Top Three Seller Profiles)

Problem Statement: 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.

Schema Details (Implied): The database utilizes two main tables for this query: profiles (containing user identity details) and deals (containing transaction amounts and dates).

Output Format: The output should be a table containing exactly four columns: first_name, last_name, email, and total.