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

2
3
(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
Get step-by-step solutions from verified subject matter experts
