The database of a car rental firm has three tables: customer, car and rental. One customer can have many rentals, but one car rental is associated with one and only one customer. One car can be rented many times but one rental is associated with one and only one car. Tables are created in the database car$\_$rental.

customer$\_$id is the primary key in the customer table. car$\_$id is the primary key in the car table. rental$\_$id is the primary key in the rental table. customer$\_$id and car$\_$id are foreign keys in the rental table. TO DO IMPORTANT :Select the database car$\_$rental. Use SQL queries to answer $10$ questions of your own choice. For each question provide the question description, SQL code and the output table. The $10$ queries should contain at least one:

ORDER BY clause

WHERE clause

GROUP BY clause

HAVING clause

INNER JOIN clause

Subquery

Mathematical Expression $($calculated field$)$ NOTE: After each question provide your $(1)$ query description $(2)$ SQL query AND $(3)$ screenshot of the result table $($output table$)$