Questions for Cars

 

  1. How many cars were sold by William Donahue on September 13, 2005?
  2. What is the make, model and color of the car with the VIN XXXXX?
  3. Who sold the car with the highest list price so far this year?

 

  1. How much did "agent so and so" spend on his latest purchase?
  2. How much did salesperson "argu" sell in a given year?
  3. How much longer does customer "parameter" have left on their warranty?

 

  1. What is the price of vehicle ID : 123?
  2. How many new cars are for sale?
  3. What is the current mileage on vehicle ID:  555?
  4. What was the amount of commission earned by salesman Bob Smith?
  5. What is the most expensive car?
  6. Which salesperson has soled the most vehicles?

 

  1. Who was the worst performing salesman last month?
  2. Which customers have purchased more than 2 cars?
  3. Which customers have bought their last car more than 8 years ago?

 

  1. How much is model X selling for now? (sticker price)
  2. What kind of tires are on model X?
  3. How many cars did salesman Joe sell last month?
  4. How many cars are on the lot?
  5. What was last week's total profit?

 

 

  1. How many Hondas are in stock?
  2. How many sales has John Smith made?
  3. How many cars has customer XYZ purchased?

 

  1. Which model sold the most during 2003?
  2. Which salesperson sold the most vehicles during July 2004?
  3. Which years between 2000-2005 had the lowest total sales?