SELECT name FROM pilot WHERE pilot_id NOT IN (SELECT Winning_Pilot  FROM MATCH WHERE country  =  'Australia')
What are the names of the pilots that have not won any matches in Australia?
SELECT name FROM pilot WHERE pilot_id NOT IN ( SELECT Winning_Pilot FROM MATCH WHERE country = 'Australia ' )
select name from pilot where pilot_id not in ( select winning_pilot from match where country = value )
What are the names of the pilots that have not won any matches in Australia ?