How many events are there?
select count(*) from event
Give me the id of stadiums that have held any of them.
select stadium_id from event
What about the stadium ids in file that are not among those?
select id from stadium where id not in (select stadium_id from event)
Show me their names.
select name from stadium where id not in (select stadium_id from event)