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