Using the word 'line' is confusing.
Please write a SQL query to find out the movie in odd line and its description is not 'boring'. And you should output the movies ordered by rating.
it should be something like
Write a SQL query to output movies with an odd numbered ID and a description that is not 'boring'. Order the result by rating.
Can the test cases be updated?
I have been submitting it and it keeps failing when I run it.
Below is the screenshot.
@david120 Good Suggestions, thanks.
@pinkupanigrahy try this:
select * from cinema where mod(id, 2) = 1 and description != 'boring' order by rating DESC ;
Ran my query after test case update. Got proper output with below.
Thanks for the suggestion.
where mod(id, 2) = 1 and description <> 'boring'
order by rating DESC;
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.