CREATE TABLE song (artist_name VARCHAR2)
CREATE TABLE artist (artist_name VARCHAR2)

Find the names and number of works of the three artists who have produced the most songs.
SELECT T1.artist_name, COUNT(*) 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
SELECT "T1"."artist_name", COUNT(*) FROM "artist" "T1" JOIN "song" "T2" ON "T1"."artist_name" = "T2"."artist_name" GROUP BY "T2"."artist_name" ORDER BY COUNT(*) DESC FETCH FIRST 3 ROWS ONLY