Write the join queries for the database described in the attached documents. The assignment directions are contained in the following pdf file named Word SQL Assignment:

Multi-table query assignment. Due 3-22-13 Create SQL queries to extract the following from the tables, whose metadata is shown. Table: city column name data type size notes about the data Number Text Text Text Number ID 11 City ld Code (primary ke 35 Name of name count 3 Country Code foreign Key to Country(Code) District Population 20 Table: country column name data type size notes about the data Country Code (primary ke street address Asia, Europe, North America, Africa Oceania, Antarctica, South America Code Text Name Text 52 Continent SurfaceArea IndepYear Population Text Text number Number Number 13 26 10,2 6 Year of independence LifeExpectancy Number (3,1) Number(10,2) Number(10,2) GNP GNPOld LocalName GovermentForm HeadOfState Capital Code2 Text Text Text Number Text 45 45 60 11 foreign Key to City (ID) Table: countrylanguage column name data type size notes about the data Country Code (primary key) foreign Key 3 to Country Code 30 Language (primary key) CountryCode Text Text Text Number Language IsOfficial Official Language (T or F) Percenta