Use the tables below to create queries to answer these questions:
1. What is the average initial margin and average actual margin (if applicable) by make and model?
2. For each month by region, on average how long does a customer take topurchase?
3. For each month by region, what percentage of test drive requests result insales?
4. By region, what is the average number of test drives completed by a vehicle within the first week of being listed?
5. How often does a customer complete the first test drive appointment she schedules?
Comments