CREATE TABLE song (song_name TEXT, artist_name TEXT, country TEXT, f_id DECIMAL, genre_is TEXT, rating DECIMAL, languages TEXT, releasedate TIME, resolution DECIMAL)
CREATE TABLE genre (g_name TEXT, rating TEXT, most_popular_in TEXT)
CREATE TABLE files (f_id DECIMAL, artist_name TEXT, file_size TEXT, duration TEXT, formats TEXT)
CREATE TABLE artist (artist_name TEXT, country TEXT, gender TEXT, preferred_genre TEXT)

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
SELECT "artist_name" FROM "song" WHERE "resolution" > 500 GROUP BY "languages" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1