SELECT Aircraft FROM aircraft WHERE Aircraft_ID NOT IN (SELECT Winning_Aircraft FROM MATCH)
List the names of aircrafts and that did not win any match.
SELECT Aircraft FROM aircraft WHERE Aircraft_ID NOT IN ( SELECT Winning_Aircraft FROM MATCH )
select aircraft from aircraft where aircraft_id not in ( select winning_aircraft from match )
List the names of aircrafts and that did not win any match .