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

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 FETCH FIRST 1 ROWS ONLY