Custom Names SQL Practice!

Question

Let's help the pilots find out details about their flights.
You are given the following tables named pilots and flights.

Write a query to output the flight ID, full name of the pilot who is responsible for the flight, the country where the flight will land, and the duration of the flight (flight_id, fullname, landing_country, duration).

Answer?

Answer 1

And your question is ❓

Answer 2

Answer:

SELECT flight_id, fullname, landing_country, duration
FROM pilots, flights
WHERE flights.id=pilots.flight_id
ORDER BY flight_id;

It will take.