List singer names and number of concerts for each singer.
create table singer_in_concert (singer_id varchar, PRIMARY KEY (singer_id)); create table singer (name varchar, singer_id varchar, PRIMARY KEY (name))
select t2.name, count(*) from singer_in_concert as t1 join singer as t2 on t1.singer_id = t2.singer_id group by t2.singer_id