NEW Car Questions - James Madison University



NEW Car Questions

1. What car models were offered in the year 2005?

2. What brand of cars sold the most this year?

3. Which sales representative had the highest commission in January 2005?

4. What is the name of the Employee with the ID number 1000023?

5. What was the most popular color of car this year?

6. How many cars were sold on April 6, 2006?

7. What is the total cost of all trade in vehicles in 2003?

8. How many customers were uninsured on the date of purchase?

9. How many vehicles are being held for sale?

10. How many cars has customer 100333045087 purchased overall?

11. How many cars were sold in 2005?

12. Which sales person had the most sales (in dollar amount) in 2003 and what was the amount?

13. What car make sold the most since the creation of the car dealership?

14. What options are already installed on a (year)(make)(model)?

15. How many different customers have purchased cards from the car dealership?

16. What is the most common form of referral to the car dealership?

17. Who is the most preferred sales person in the car dealership?

18. Which financier is most commonly used to finance customer’s vehicle purchases?

19. How many trade-in vehicles were purchased by the dealership in 2004?

20. What percent of customers purchased an extended warranty with their vehicle purchase?

21. What is the cheapest car on the lot?

22. What is the average asking price of all cars?

23. Which specific customer bought the most cars?

24. What is the number of used cars on the lot?

25. Which customers haven’t bought a car in a year?

26. Which customers have sold their cards to our dealership?

27. What is the total number of used cars sold?

28. What is the total number of used cars ever bought?

29. What make of car was the most recently sold?

30. What was the first car ever sold?

31. How many cars of make X are on the lot?

32. How many cars of model X from make X are on the lot?

33. What are the different colors available for car make X?

34. How many cars has a certain salesman sold?

35. How many cars of make X have been sold?

36. How is the top seller at this car dealership?

37. Who is the worst seller at this car dealership

38. When was the highest and lowest sales months?

39. How much commission was made versus total income of the dealership?

40. What is the overall customer satisfaction of an individual salesperson?

41. What car make is the most popular?

42. Which customers haven’t purchased a car in the past 5 years?

43. What cars are 6 months old?

44. Which cars were delivered this year?

45. What was the total price for modifications on a car bought by “Super Man”?

46. What were the modifications done to a car purchased by “Super Man”?

47. What size motor does “car” have?

48. How much did “car” sell for?

49. How much commission was made on “car”?

50. Is there a warranty on “car”? Is it still valid?

51. How much taxes do we need to report to IRS?

52. Print a list of customers who financed their cars through the dealer

53. Do we have model X in the color green in stock?

54. How many customers traded-in their old cars last year?

55. What colors are available for model X?

56. How many doors does model X have?

57. What is the phone number of salesperson X?

58. Is the vehicle with vin X new or used?

59. What is the most popular model of all time?

60. How many vehicles are currently on the lot of year X and model Y?

61. What is the average difference between the list price and the actual purchase price for salesperson X?

62. When was the vehicle with vin number X manufactured?

63. Is the mileage for vehicle X under 80,000 miles?

64. How many sales in year X were from customers that live out of state?

65. How much lower than the list price is the actual sale price on average for all cars sold?

66. What is the average sale price for cars sold by John Smith this year?

67. Who has the highest dollar amount of commissions among the sales people?

68. What is the total of all cars that were sold on July 10th 2004?

69. Which cars have been sold by the dealership at two different times?

70. Which car is the oldest car on the lot?

71. How many cars for sale were manufactured in 2006?

72. What is the range of list and sale prices of cars sold by Pat Duncan?

73. Which make and model of car has Patty Sue sold the most of this year?

74. What is the total net profit of all sales processed this year?

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download