- Import the following database file city.sql
- Add to the database the following table and data:
- Add a EDUCATION table with the following columns; country code as a primary key, literacy rate, male literacy rate, female literacy rate
- Add data for the following countries
AFG, 38, 52, 24
DEU, 99, 99, 99
NLD, 99, 99, 99
USA, 99, 99, 99
- Execute the following commands and save the results.
- Display the languages of the United States
- Display the cities of Germany and the population of each city
- Display the female literacy rate of all countries
- Submit the saved results file using the below name or paste as a text submission.
- Creating the database, adding the table with data, and each query is each worth 20% of the homework grade.
YourLastName_p1.txt