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
Temukan nama dan jumlah karya tiga artis yang telah menghasilkan lagu terbanyak.
CREATE TABLE song (artist_name VARCHAR); CREATE TABLE artist (artist_name VARCHAR)