+ 1
Can someone please explain why it's not running?
/* 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 */ SELECT artist, title FROM songs WHERE LOWER(title) LIKE '%love%' ORDER BY rating DESC Solved! The right answer is SELECT title, artist FROM songs WHERE LOWER(title) LIKE '%love%' ORDER BY rating DESC
2 ответов
+ 3
Are the fields out of order? The problem statement says title, artist; and the query has artist, title.
+ 2
Is it from the Introduction to SQL > Query Techniques > Music and Love! ?
I don't have a pro access but your SQL seems fine to me.
If the test case(s) is not locked, you can compare your result and the expected output and find the difference.