Database: concert_singer
Question: Find the number of concerts happened in the stadium with the highest capacity .
SQL:
select count(*) from concert where stadium_id = (select stadium_id from stadium order by capacity desc limit 1)