Task: Text to Code
Input (English): Step 1: find the rows in song table whose resolution greater than 500.
Step 2: find each value of artist_name in the results of step 1 ordered descending by number of rows that correspond of each value.
Step 3: only show the first row of the results
Output (English): SELECT artist_name FROM song WHERE resolution > 500 GROUP BY artist_name ORDER BY Count ( * ) Desc LIMIT 1