Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now

se the Prime Minister database (Prime_Min…

Write SQL SELECT statements to retrieve the following information from the Prime Minister database.
1. List the name, year commenced service as Prime Minister, party, state represented and the 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 (5 marks)
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. (5 marks)
3. List the name, the year that they commenced service as Prime Minister, the party they led and the year in which they left office of each Prime Minister of a Labor government. Order by the year they commenced service and the Prime Minister’s name. (5 marks)
Charles Sturt University Subject Outline
ITC114 201390 S I-29 October 2013-Version 1 Page 13 of 21
4. Did any Deputy Prime Minister(s) subsequently become Prime Minister? List the Deputy 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.(5 marks)

You Want A Similar Paper Done? Don’t be stressed, Click Here To Order this essay!!


Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now