Use the Prime Minister database (Prime_Minister_2013.sql) available from the Interact site. Answer the following queries using that database.
You are required to submit:
The appropriate SQL statements, which should be copied from your SQL code in MySQL, and 1. pasted into your submission file; and
Screenshots of the resultant tables which are to be pasted into your assignment file immediately 2. after the SQL code. Typing or manually drawing the results is NOT acceptable.
Write SQL SELECT statements to retrieve the following information from the Prime Minister database.
List the name, year commenced service as Prime Minister, party, state represented and the 1. name of the Deputy Prime Minister for each Prime Minister that served for less than 3 years. Order by the year they commenced service as Prime Minister in descending order.
2. List the name, party, recreation(s), name of their spouse and number of children of each Prime Minister of a Labor government who had four or more children and enjoyed outdoor sports.
3. List the name, the year that they commenced service as Prime Minister, the party they led and each Prime Minister of a Labor government. Order by the the year in which they left office of year they commenced service and the Prime Minister's name.
Did any Deputy Prime Minister(s) subsequently become Prime Minister? List the Deputy 4. Prime Ministers name, the year that he/she commenced as Deputy Prime Minister, the year he/she commenced as Prime Minister and the party that they led. Order the list by name, year
commencing as Prime Minister and Party in descending order.
Attachment:- ASSIGNMENT.rar