Company: Amazon Senior business research scientist_14april
Difficulty: medium
As part of the Amazon Marketplace performance report for June 2022, you are tasked with identifying the top-performing seller profiles based on the total value of deals they completed during the month. You need to generate a report listing the top three sellers with the highest total sales amounts in June 2022. The result should have the following columns: first_name | last_name | email | total . total - The total value of all deals made by the seller in June 2022 The result should be: Sorted in descending order by total . Limited to the first three records. Note: Only deals for June 2022 should be included in the report. Schema profiles name type description id SMALLINT unique ID, primary key first_name VARCHAR(255) First name of seller last_name VARCHAR(255) Last Name of seller email VARCHAR(255) Email of seller deals name type description profile_id SMALLINT foreign key into profiles.id dt VARCHAR(19) Deal datetime amount DECIMAL(5,2) Deal amount Sample Data Tables profiles id first