SELECT Name FROM phone WHERE Phone_id NOT IN (SELECT Phone_ID FROM phone_market)
List the names of phones that are not on any market.
SELECT Name FROM phone WHERE Phone_id NOT IN ( SELECT Phone_ID FROM phone_market )
select name from phone where phone_id not in ( select phone_id from phone_market )
List the names of phones that are not on any market .