Find Sales Quota of Supervisors who are 1 level above employees.

 

2. Find average amount negotiated for each agent for all their sales in last 100 days

 

3.Find what is the difference between first listed and last listed prices for a car (For each CarID there could be multiple listings, CarID+ListDate combination is unique)

 

4.Find popular models for each month in the year 2018.

 

 

5.Find 5 agents who sold most number of cars as well as most revenue generated (those agents should be in both top revenue and most number of cars)

 

 

6.Find Full Names of buyers who bought another vehicle within a year

 

 

PK Buyer BuyerlD FirstName LastName DOB Gender City State ||+ PK UK1 ListedCars ListID CarlD Maker Model Year Color ListPrice UK1 ListDate Sales BuyerID AgentID ListID SalePrice Is_Financed Rate Down Payment SalesAgent PK AgentID FK FirstName LastName DOB Gender HireDate QuarterlyQuota YearlyQuota SupervisorID HH