What is the maximum rating for all the songs?
select max(rating) from song
Which songs are the top 2 rating ones?
select * from song order by rating desc limit 2
What about top 3?
select * from song order by rating desc limit 3
What are the names and countries of origin for the artists of these songs?
select t1.artist_name, t1.country from artist as t1 join song as t2 on t1.artist_name = t2.artist_name order by t2.rating desc limit 3