Database: aircraft
Question: List the names of aircrafts and that did not win any match.
SQL:
SELECT Aircraft FROM aircraft WHERE Aircraft_ID NOT IN (SELECT Winning_Aircraft FROM MATCH)