The following query is supposed to retrieve all aircraft and pilot information that leave from Perth...

Transcribed Image Text:

The following query is supposed to retrieve all aircraft and pilot information that leave from Perth Airport. It seems to be working but for some reason, one of the flights is not appearing. The missing flight is one where the plane has no co-pilot. Describe what is going wrong with this query. How would you fix it? SELECT p.planeModel, f.flightTo, f.flightFrom, p.pilotName, c.coPilotName FROM Plane p INNER JOIN Flight f ON p.planeId = f.planeId INNER JOIN Pilot p ON f.pilotId = p.pilotId RIGHT OUTER JOIN Pilot c ON f.coPilot = c.pilotId WHERE f.flightFrom = 'PER'; The following query is supposed to retrieve all aircraft and pilot information that leave from Perth Airport. It seems to be working but for some reason, one of the flights is not appearing. The missing flight is one where the plane has no co-pilot. Describe what is going wrong with this query. How would you fix it? SELECT p.planeModel, f.flightTo, f.flightFrom, p.pilotName, c.coPilotName FROM Plane p INNER JOIN Flight f ON p.planeId = f.planeId INNER JOIN Pilot p ON f.pilotId = p.pilotId RIGHT OUTER JOIN Pilot c ON f.coPilot = c.pilotId WHERE f.flightFrom = 'PER';

Answer rating: 100% (QA)

The issue with the provided SQL query is that it uses an INNER JOIN between the Flight table and the ... View the full answer