SELECT name FROM stadium WHERE stadium_id NOT IN (SELECT stadium_id FROM concert)
Show the stadium names without any concert.
SELECT name FROM stadium WHERE stadium_id NOT IN ( SELECT stadium_id FROM concert )
select name from stadium where stadium_id not in ( select stadium_id from concert )
Show the stadium names without any concert .