Translate the following question to SQL: What is the name of the artist, for each language, that has the most songs with a higher resolution than 500?

Schema: CREATE TABLE genre (
    g_name varchar2(20) NOT NULL  PRIMARY KEY,
    rating varchar2(10),
    most_popular_in varchar2(50),
    UNIQUE (g_name)
);

CREATE TABLE artist (
    artist_name varchar2(50) NOT NULL  PRIMARY KEY,
    country varchar2(20),
    gender varchar2(20),
    preferred_genre varchar2(50),
    UNIQUE (artist_name),
    FOREIGN KEY (preferred_genre) REFERENCES genre(g_name)
);

CREATE TABLE files (
    f_id number(10) NOT NULL  PRIMARY KEY,
    artist_name varchar2(50),
    file_size varchar2(20),
    duration varchar2(20),
    formats varchar2(20),
    UNIQUE (f_id),
    FOREIGN KEY (artist_name) REFERENCES artist(artist_name)
);

CREATE TABLE song (
    song_name varchar2(50)   PRIMARY KEY,
    artist_name varchar2(50),
    country varchar2(20),
    f_id number(10),
    genre_is varchar2(20),
    rating number(10),
    languages varchar2(20),
    releasedate Date,
    resolution number(10) NOT NULL,
    UNIQUE (song_name),
    FOREIGN KEY (genre_is) REFERENCES genre(g_name),
    FOREIGN KEY (f_id) REFERENCES files(f_id),
    FOREIGN KEY (artist_name) REFERENCES artist(artist_name),
    rating number(10) check(rating>0 and rating<11),
);
user
SELECT artist_name FROM song WHERE resolution  >  500 GROUP BY languages ORDER BY count(*) DESC LIMIT 1
assistant