Show me the list of all id and names of all artists that have at least 3 albums 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
artists with at least 3 albums refers to COUNT(*) >= 3; list of all id and names refers to SELECT ArtistId, Name; alphabetical order refers to ORDER BY Name;