Task Use the prime_minister database (prime_minister.sql) from the Interact Resources site. Answer the following queries from that database. You are required to submit: 1.The appropriate SQL...

Task Use the prime_minister  database (prime_minister.sql) from the Interact Resources site. Answer the following queries from that database.

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;
2.Your SQL script, which is either for each question--one-step solution, or for the two sub-questions of each question-- two-step solution; and
3.Screenshots of the resultant tables which are to be pasted into your submission file immediately after the SQL code for that query. Typing or manually drawing the results is NOT acceptable.