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
What are the names of the three artists who have produced the most songs, and how many works did they produce?
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 as t1 join song as t2 on t1 . artist_name = t2 . artist_name group by t2 . artist_name order by count ( * ) desc limit value
What are the names of the three artists who have produced the most songs , and how many works did they produce ?