SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1
Which year has most number of concerts?
SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count ( * ) DESC LIMIT 1
select year from concert group by year order by count ( * ) desc limit value
Which year has most number of concerts ?