Posts by Esteves • 97 points
3 posts
-
-3
votes2
answers62
viewsQ: co-pilots who made the most flights
I have this question: Name and number of flight hours of the copilot who made the largest number of flights. It is intended to know the exact number of flights made by each of these copilot And I…
-
1
votes1
answer150
viewsQ: NOT IN SQL ( I want to select pilots who have never done a certain route) how?
I want to select the pilots (in this case commanders or co-pilots) who have never flown the route 12345 . At the moment SQL is returning all pilots and I want to return only the 18200 the 25100 and…
-
9
votes3
answers1244
viewsQ: How to make a NOT IN SQL?
I want to get all pilots who have never performed flights on route 12345, I have tried with NOT IN and so on: SELECT pl.id FROM Piloto pl, Voo v, Rota r WHERE pl.id = v.id_comandante AND pl.id =…