Which artist has the most albums?
select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t2.name order by count ( * ) desc limit 1
Yes, I mean it.
which artist has the least number of albums?
select t2.name from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t2.name order by count ( * ) asc limit 1
Can you tell me the artist ID number of the Iron Maiden?
select t1.artistid from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t2.name order by count ( * ) desc limit 1
Can you tell me the artist ID number of the Aaron Copland & London Symphony Orchestra.
select t1.artistid from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t2.name order by count ( * ) asc limit 1