Task: Text to Code
Input (English): Step 1: for each value of artist_name in files table, calculate number of rows.
Step 2: show each value of artist_name in files table along with the corresponding number of rows ordered descending by the results of step 1.
Step 3: only show the first 3 rows of the results
Output (English): SELECT artist_name , Count ( * ) FROM files GROUP BY artist_name ORDER BY Count ( * ) Desc LIMIT 3