Use the Prime Minister database (Prime_Minister_2000.sql) which is available in ITC114 subject Interact site.

Write and run SQL statements to complete the following tasks

1. List the name of the states and the number of prime minister from each state. (3 marks)

2. List the name of the deputy prime ministers and the number of times served as a deputy prime minister where a deputy prime minister served more than once (3 marks)

   
   
3. Did anyone become a Prime Minister where the difference commencement year (yr_comm) and birth year (birth_yr) is greater than or equal to 65? If so, then please list the name of Prime Minister, the party that they led, birth year, and commencement year. (3)

4. For each Prime Minister that did not lead either Labor or Liberal government, had less than four children and enjoyed "cricket", "racing", "swimming", "tennis as recreation, list their name, party, recreation(s), name of their spouse and number of children. (3 marks)

5. 
   

   List the Prime Minister Name, Deputy Prime Minister name, and the party that they led where Prime Minister and Deputy Prime Minister from the same party but not from Labor and they served more than once. (3 marks)