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
What are the names and ids of artists with 3 or more albums, listed 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
select t2 . name , t1 . artistid from album as t1 join artist as t2 on t1 . artistid = t2 . artistid group by t1 . artistid having count ( * ) > = value order by t2 . name
What are the names and ids of artists with 3 or more albums , listed in alphabetical order ?