List all the song names and the resolutions in descending order of resolution.
select song_name, resolution from song order by resolution desc
Which one has the highest resolution?
select song_name, resolution from song order by resolution desc limit 1
What about the lowest one?
select song_name, resolution from song order by resolution asc limit 1
What is the gender and name of the corresponding artist of that song?
select t1.gender, t1.artist_name from artist as t1 join song as t2 on t1.artist_name = t2.artist_name order by t2.resolution limit 1