How do I solve this?

Question

select the song title and artist from the songs table
where the song title contains the word 'love'
and order the results by the rating in descending order

Answer 1

I think this is the answer:

Select title, artist
From songs
Where title like '%love%'
Order By rating desc

Answer 2

Use a SELECT statement.
You can learn about SQL in Sololearn.
https://www.sololearn.com/learn/courses/sql-introduction