620. Not Boring Movies

id is the primary key (column with unique values) for this table.
Each row contains information about the name of a movie, its genre, and its rating.
rating is a 2 decimal places float in the range [0, 10]

Write a solution to report the movies with an odd-numbered ID and a description that is not "boring".

Return the result table ordered by rating in descending order.

The result format is in the following example.

Input:
Cinema table:

Output:

Explanation:
We have three movies with odd-numbered IDs: 1, 3, and 5. The movie with ID = 3 is boring so we do not include it in the answer.

解答：

SELECT id, movie, description, rating
FROM Cinema
WHERE description != 'boring' 
HAVING MOD(id,2) = 1
ORDER BY rating DESC