This paper circulates around the core theme of 1. The appropriate SQL statements for each query, which should be copied from your SQL code in MySQL and pasted into your submission file, together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Your Submission
You are required to submit:
1. The appropriate SQL statements for each query, which should be copied from your SQL code in MySQL and pasted into your submission file, and
2. Screenshots of the resultant tables which are to be pasted into your submission file immediately after the SQL code for that query.
3. Typing or manually drawing the results is NOT acceptable.
Tasks
Part 1
Open the database prime_ minister database (prime_minister.sql). Answer the following queries using this database.
1. Find certain Governors General of Australia.
1. Find all Governors General of Australia who were Barons at the time of their appointment. List them by Title and name and date that they were appointed to the position. Order the list by ascending date of appointment. (5 marks)
2. Now, format the date of appointment as day of the week, day of the month, month and year; eg. Monday, 01 January, 1901. Order the list by ascending date of appointment. (5 Marks)
2. Find certain Leaders of the Opposition.
1. Find all Leaders of the Opposition and their date of appointment, who assumed their position after 01/01/1980. (5 marks)
2. For each Leader of the Opposition listed, add their wife’s name and their date of marriage. (5 Marks)
3. Find certain Governors General of Australia.
1. List the title, name, date of appointment for Governors General of Australia who were appointed between 01 January 1930 and 01 January 1960. Order by ascending date of appointment. (5 marks)
2. Now add to the results of q3a, the list of Prime Ministers who appointed them and all Leaders of the Opposition who served during their appointment as Governor General of Australia. Order by ascending date of appointment. (5 marks)
4. Who are the Opposition Leaders who subsequently became Prime Minister after 1930?
1. List their name, the date they were elected Opposition Leader and the date they were elected Prime Minister. The dates must be formatted as day of the week, day of the month, month in digits and year in four digits; eg. Monday, 01/01/1901. Order the list in ascending date of appointment as Prime Minister. (15 marks)
2. Now add their Deputy Prime Minister’s name and the party that they led. Order the list by ascending date of appointment as Opposition Leader. (10 marks)