CREATE TABLE MATCH (Aircraft VARCHAR, Aircraft_ID VARCHAR, Winning_Aircraft VARCHAR)
CREATE TABLE aircraft (Aircraft VARCHAR, Aircraft_ID VARCHAR, Winning_Aircraft VARCHAR)

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