Considering the $3$ tables below:

a$.(5$pts$)$Write a query to retrieve the Order numbers and their respective

dates for the salesman number $5001.$

b$.(5$pts$)$Write a query to retrieve how many orders have an amount greater

than $1000$$$,$ regardless the salesman

c$.(5$pts$)$Write a query to retrieve how many orders were placed in September,

regardless the salesman.

d$.(5$pts$)$Use a subquery approach to find all orders attributed to salesmen in

Paris.

e$.(5$pts$)$I would like to retrieve the customers with a grade higher than the

average of all customers in New York. Write a query $($with a subquery!

f$.(5$pts$)$How about if I wanted to retrieve the customers whose grades are

higher than every customer in New York. Write a query with a subquery.