What are the names of the top 3 artists with the largest number of songs?
SELECT T1.artist_name FROM artist AS T1 JOIN song AS T2 ON T1.artist_name   =   T2.artist_name  GROUP BY T2.artist_name ORDER BY count ( * )  DESC LIMIT 3
top 3 artists with the largest number of songs refers to selecting artist_name and ORDER BY COUNT(*) DESC LIMIT 3;