Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Download the MONDIAL database (the mondial-schema.psql is used to create the tables, mondial-inputs.psql contains the data along with the queries to load it into the
Download the MONDIAL database (the mondial-schema.psql is used to create the tables, mondial-inputs.psql contains the data along with the queries to load it into the database, and mondial-drop-tables.psql contains the queries to delete these data once this assignment is completed). 1 SQL exercises (100 pts) Load the data in the database and list the queries and their results for each of the following questions. 1. (20 pts) How many distinct airports are in the database? 2. (20 pts) What's the longest country code and how many characters it has? 3. (20 pts) Which country has the largest number of airports? 4. (20 pts) Which country has the largest largest land area comprised of islands? 5. (20 pts) Which countries have a population between 1% and 10% of the world population
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started