Show all the names of all the festivals.
select festival_name from festival_detail
Show me the corresponding year for these festivals.
select festival_name, year from festival_detail
What were the amount of festivals for each of these years?
select year, count(*) from festival_detail group by year
Which of these years has more than one festival?
select year from festival_detail group by year having count(*) > 1