CREATE TABLE artist (artist_id NUMBER, artist CLOB, age NUMBER, famous_title CLOB, famous_release_date CLOB)
CREATE TABLE volume (volume_id NUMBER, volume_issue CLOB, issue_date CLOB, weeks_on_top NUMBER, song CLOB, artist_id NUMBER)
CREATE TABLE music_festival (id NUMBER, music_festival CLOB, date_of_ceremony CLOB, category CLOB, volume NUMBER, result CLOB)

Return the song in the volume that has spent the most weeks on top?
SELECT song FROM volume ORDER BY weeks_on_top DESC LIMIT 1
SELECT "song" FROM "volume" ORDER BY "weeks_on_top" DESC FETCH FIRST 1 ROWS ONLY