Question: Write an SQL query that will display a list of all customers (lastName, firstName, phone) and the number of cars that each has purchased from
Write an SQL query that will display a list of all customers (lastName, firstName, phone) and the number of cars that each has purchased from the dealership. Sort the list by number of cars from most to least. Copy and paste your query in the large text area below. How many cars have been purchased by the customer who is listed third in the results of the query?

customer customerKey lastName firstName phone street1 street2 salesperson salesPersonkey lastName firstName hireDate salary purchase purchasekey dateSold odometer price customerKey salesPersonKey VIN state zipcode autom obile VIN year make model body color
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
