Task: Text to Code
Input (English): SQL: SELECT Name , ArtistId FROM Artist GROUP BY ArtistId HAVING Count ( * ) > = 3
Feedback: In step 1 , replace artist id in artist table in place of artist id in album table .
Output (English): 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