1. Based on the tables we used in SQL Exercise Part 3 (i.e., CEOs, Companies, Countries), write SQL queries to answer the following questions. Please include both your SQL query and result (screenshots are fine) in the answer [ 5 points each; 10 points in total for CEE 412 students; 20 points in total for CET 522 students]. Note: test your answer by execute the query in your own database. 1) Find all countries with higher population than 200,000,000. Your result should be a table of country names by population. Try convert your population values to some more readable format (e.g., use " 0.32 Billion" to represent 320,314,000 ). 2) Find the market value of the company whose CEO receives the highest one year payment. Also include the company name, the CEO name, and the corresponding payment in your result. 3) [For CET 522 Students ONLY] The level of development for each country is determined by the following criteria: A country is categorized as a Developed country if its GDP Per Capita is higher than $12,000, otherwise it is categorized as a Developing country. Add a new column into the Countries table to describe the level of development for each country. Values in that column should be either Developed or Developing (no need to show query result for this question, just paste your query statement here). 4) [For CET 522 Students ONLY] In each level of development, count the number of countries and calculate the average GDPPC. Make use of the new column you just created (don't worry about the result, neither the criteria nor the GDPPC data are completely correct). 1. Based on the tables we used in SQL Exercise Part 3 (i.e., CEOs, Companies, Countries), write SQL queries to answer the following questions. Please include both your SQL query and result (screenshots are fine) in the answer [ 5 points each; 10 points in total for CEE 412 students; 20 points in total for CET 522 students]. Note: test your answer by execute the query in your own database. 1) Find all countries with higher population than 200,000,000. Your result should be a table of country names by population. Try convert your population values to some more readable format (e.g., use " 0.32 Billion" to represent 320,314,000 ). 2) Find the market value of the company whose CEO receives the highest one year payment. Also include the company name, the CEO name, and the corresponding payment in your result. 3) [For CET 522 Students ONLY] The level of development for each country is determined by the following criteria: A country is categorized as a Developed country if its GDP Per Capita is higher than $12,000, otherwise it is categorized as a Developing country. Add a new column into the Countries table to describe the level of development for each country. Values in that column should be either Developed or Developing (no need to show query result for this question, just paste your query statement here). 4) [For CET 522 Students ONLY] In each level of development, count the number of countries and calculate the average GDPPC. Make use of the new column you just created (don't worry about the result, neither the criteria nor the GDPPC data are completely correct)
