CMIS 320 Homework 1 Due: 18 April Create a table whose attributes are as described in the 'world_bankfields' file. Load the data from the 'world_bank' file. Execute these queries. For each question, include the original number and question from this file, the SQL query and the resultset, followed by a line of asterisks. Use the style that displays SQL keywords in allcaps and identifiers are lowercase. 1- number of records 2- totals and averages of population, area, GNI (one query to get these 6 values) 3- name, population and GNI of records with null surface_areas 4- number of records with null GNI fields 5- the names and GNI of the 10 states with the largest GNI in descending order 6- the five poorest states (lowest GNI) for which there is data 7- number of states with negative GDP growth rates 8- the names and areas of the 10 biggest states in land area 9- the sum of the areas of the 10 biggest states (using a datum from the previous query) 10- names of states containing two r's in any mix of case 11- names of states containing two consecutive same vowels, i.e. aa,ee,ii,oo, or uu 12- names of states whose names have 'land' 13- names of states whose names contain 'ia' but do not end in 'ia' 14- names of the states with the shortest names (you can use 2 queries to do this) 15- the names,population,area and density of the 10 most densely populated states. density in people per sq km is derived from population/area*1000. name that column Denstiy. use the round or trunc function to round the density values. 16- the names,population,area and density of the 10 least densely populated states for which there is appropriate data, in order by density 17- name, population, percapita GNI of the 10 states with the highest percapita GNI in dollars per person(derived from GNI/population*1000) in order of percapita GNI 18- name, population, percapita GNI of the 10 states with the lowest percapita GNI for which there is data, in order of percapita GNI 19- names,GNI,PPP_GNI, and difference between these two GNI values of the states whose GNI is larger than its PPP_GNI 20- names,PPP_GNI,GNI and percentage that PPP_GNI is of GNI for the states whose such percentage is more than 500 (i.e. their PPP_GNI is more than 5 times their GNI), ordered by this percentage. Round it to the nearest integer. 21- frequency count of the number of names of different lengths. I.e. number of names of length 22, number of length 21 etc. Hint: group by length of name. Order by the lengths. 22- frequency count of the number of names that start with each letter. I.e. number of names that start with A, number of names that start with B etc. Hint: group by leftmost 1 character of name using the Substr() function. Display in decreasing order by count.