1. ) Following are details of space shuttle flights in 2000. Draw a data model to record details of flights, shuttles, and commanders. NASA requires you to record details of the commander such as full name and date of birth. For a shuttle, it wants to know the date it was built.

Flight	Shuttle	Launch date	Objective	Crew size	Commander
97	Endeavour	02-11-2000	Shuttle Radar Topographic Mission	6	Kregel
98	Atlantis	05-19-2000	ISS-2A.2 SpaceLab Double Cargo Module	7	Halsell
99	Atlantis	09-08-2000	ISS-ISS-2A.2B Outfitting ISS	7	Wilcutt
100	Discovery	10-11-2000	ISS-3A Integrated Truss Structure Z1, PMA-3, CMG's	7	Duffy
101	Endeavour	11-30-2000	ISS-4A ITS P6, Photovoltaic Module, Radiators	5	Kregel

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)