SQL-Challange

There are two file:

  • Flights.csv
  • Passangers.csv

Please create a Postgres database.

Create a refrence from the id column from flights to the flightid column in passenger.

Task:

Jo is panciking and needs to get to Cario and is from Seattle. You will have to find the nearest airport. A flight has been booked and this new flight(s) is an option please book the new flight(s) and cancel the old flight.

We will discuss this on Tuesday.