Show me all artists with at least 3 albums.
select * from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t1.artistid having count(*) >= 3
Show me their names and ids.
select t2.name, t1.artistid from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t1.artistid having count(*) >= 3 order by t2.name
Sort them in alphabetical order.
select t2.name, t1.artistid from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t1.artistid having count(*) >= 3 order by t2.name