Question: MySQL QUESTION Create a select that outputs the top 5 selling cars using the data from the tables below CREATE TABLE cars ( car_ID int

MySQL QUESTION

Create a select that outputs the top 5 selling cars using the data from the tables below

CREATE TABLE cars ( car_ID int AUTO_INCREMENT, car_Name varchar(60), car_reg int, car_Stock int, car_Price float, PRIMARY KEY (car_ID) );

CREATE TABLE Sales ( Model_ID varchar(60), Person_ID int NOT NULL, Cost int NOT NULL, car_Sales_ID INT NOT NULL, Date_Purchased DATE NOT NULL, Sale_Price float, PRIMARY KEY (Model_ID) FOREIGN KEY (car_Sales_ID) REFERENCES cars(car_ID) );

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!