Database: aircraft
Question: What are the names of all aicrafts that have never won any match?
SQL:
SELECT Aircraft FROM aircraft WHERE Aircraft_ID NOT IN (SELECT Winning_Aircraft FROM MATCH)