Create Database and Tables FOR A CAR DEALERSHIP. Insert Values in your database $(50$ entries per table will be enough$)($instead of providing SQL code for insert, provide a snapshot of the tables$)(20$ Marks$)$

b$)$ Run $10$ general queries. $($e$.$g$.$ in the CAR SYSTEM $)$

c$)$ Write any three complex SQL codes to retrieve data from your database $($Involving two or more tables, subqueries, lead$/$lag$,$ aggregate$).$ Explain what you are trying to retrieve and how your query is working $($looking for logic$).$