SQL Important Questions

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?

If you need any help then please contact us at contact@codersarts.com and get instant help within affordable price.

12 views0 comments

Recent Posts

See All