1. Write five SQL queries from the above data demonstrating the following skills. I just need to see the SQL scripts, not the results. In all queries, the query needs to include more than one table.
   1. Use of the Group by Statement
   2. Use of the between statement
   3. Use of the having statement
   4. Use of the an order by statement
   5. Use of a subquery (IN or EXISTS)