SELECT Aircraft FROM aircraft WHERE Aircraft_ID NOT IN (SELECT Winning_Aircraft FROM MATCH)
What are the names of all aicrafts that have never won 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 )
What are the names of all aicrafts that have never won any match ?