Database: concert_singer
Question: What are the names , themes , and number of singers for every concert ?
SQL:
select t2.concert_name ,  t2.theme ,  count(*) from singer_in_concert as t1 join concert as t2 on t1.concert_id  =  t2.concert_id group by t2.concert_id