Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases New Opportunities For Connected Data

Authors: Ian Robinson, Jim Webber, Emil Eifrem

2nd Edition

1491930896, 978-1491930892

More Books

Students also viewed these Databases questions