World database, Part1 The dataset The world database contains three tables, city, country, and countrylanguage. You can see the schema of the tables in their instantiation below. If you'd like to practice your queries in a local environment you can download the sql file: copy Link into browser to get data: https://gofile.io/dpXnCKK Complete all of the following coding challenges: CREATE TABLE city ( id integer NOT NULL, name text NOT NULI., countrycode character (3) NOT NULL, district text NOT NULL, population integer NOT NULL ); CREATE TABLE country code character (3) NOT NULL, name text NOT NULL, continent text NOT NULL, region text NOT NULL, surface area real NOT NULL, indepxe ar amallint, population integer NOT NULL, li Esexpectancy, real, no numeric (10,2) gripold numeric (102) localname text NOT NULL, government form text NOT NULL, headofstate text, capital integer, code 2 character (2) NOT NULL, CONSTRAINT country continent check CHECK COC (continent = "Asia': text) OR (continent = 'Europe'::text)) OR (continent North America text) OR (continent 'Africa'::text)) OR (continent = Oceania'text)) OR (continent = Antarctica'::text)) OR (continent = South America Estext) ); CREATE TABLE country languags ( country code character (3) NOT NULL, lang, text NOT NULL, is official boolean NOT NULL, percentage real NOT NULL queries 1: Show the population of Germany queries 2: Show the name, gup, and population for each country where the area is over 5,000,000 and the population is not null or zero. Sort showing the highest populations first queries 3: Show the name and continent for each country where the area is less than 2,000 and the gap is more than 50,000 queries 4. Show the name and the population for Denmark, Finland, Norway, and Sweden queries 5. Show the name of each country that begins with the letter G queries 6: Show the name and the area for countries with an area between 200,000 and 250,000 km2