CREATE TABLE ARTIST (Name VARCHAR2, ArtistID VARCHAR2)
CREATE TABLE ALBUM (ArtistId VARCHAR2)

Please list the name and id 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
SELECT "T2"."Name", "T1"."ArtistId" FROM "ALBUM" "T1" JOIN "ARTIST" "T2" ON "T1"."ArtistId" = "T2"."ArtistId" GROUP BY "T1"."ArtistId" HAVING COUNT(*) >= 3 ORDER BY "T2"."Name"