What is the name of the artist, for each language, that has the most songs with a higher resolution than 500?
SELECT artist_name FROM song WHERE resolution  >  500 GROUP BY languages ORDER BY count(*) DESC LIMIT 1
name of the artist for each language with most songs having resolution higher than 500 refers to selecting artist_name from songs where resolution > 500, grouped by language, and ordered by count of songs in descending order, limit to 1 for each language group;