Question: using the table there are three questions need those answers 1 write SQL code using the table for sales 2 SQL code for number of

using the table there are three questions

need those answers

1 write SQL code using the table for sales

2 SQL code for number of cars sold in 2020

3rd one is the last pic

1

using the table there are three questions need those answers 1 write

2SQL code using the table for sales 2 SQL code for number

3of cars sold in 2020 3rd one is the last pic 1

(JUST the Sale table). Using the dealership database you created above, wrihe a SOL code to compute the number of cars that were sold in the year 2020 Again, using the deslership datsbese you created ahove, write a SQL pode to create a report that presents a list of the car makes that are the most popular with custemers since 2020. That is, how many Toyota, Nissan, Mercedes etc have been soid since 2020. Here are the requirements for the report: 1) The report should include the car make, and the number of cars of that make that have been sold. 2) it concerns only cars sold since 2020 . 3) it should include only car makes sold at least 20 times, and sorted by decreasing order, he, from the most frequently sold to the least frequently sold

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 General Management Questions!