Find Sales Quota of Supervisors who are 1 level above employees. 2. Find average amount negotiated
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: