5. Relational Databases

Assignment: Displaying Airport Data

Introduction

This post is my assignment submission from Microsoft’s Data Science for Beginners Repository. The assignment is about “Displaying Airport Data” using SQLite. As instructed, I’m using SQLite extension that is installed inside VSCode.

Assignment

1. all city names in the Cities table
2. all cities in Ireland in the Cities table
3. all airport names with their city and country
4. all airports in London, United Kingdom

Q1

SELECT city
FROM Cities;

Q2

SELECT city
FROM Cities
WHERE country = 'Ireland'

Q3

SELECT Airports.name, Cities.city, Cities.country
FROM Cities
RIGHT JOIN Airports
  ON Airports.city_id = Cities.city;

Q4

SELECT name
FROM Airports
WHERE city_id = (SELECT id FROM Cities WHERE city = 'London');