Database: aircraft
Question: find the name of pilots who did not win the matches held in the country of Australia.
SQL:
SELECT name FROM pilot WHERE pilot_id NOT IN (SELECT Winning_Pilot  FROM MATCH WHERE country  =  'Australia')