SELECT YEAR FROM concert GROUP BY YEAR ORDER BY count(*) DESC LIMIT 1
What is the year that had the most 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
What is the year that had the most concerts ?