# ---
# title: 620. Not Boring Movies
# id: problem620
# author: Tian Jun
# date: 2020-10-31
# difficulty: Easy
# categories: 
# link: <https://leetcode.com/problems/not-boring-movies/description/>
# hidden: true
# ---
# 
# X city opened a new cinema, many people would like to go to this cinema. The
# cinema also gives out a poster indicating the movies' ratings and
# descriptions.
# 
# Please write a SQL query to output movies with an odd numbered ID and a
# description that is not 'boring'. Order the result by rating.
# 
# 
# 
# For example, table `cinema`:
# 
#     
#     
#     +---------+-----------+--------------+-----------+
#     |   id    | movie     |  description |  rating   |
#     +---------+-----------+--------------+-----------+
#     |   1     | War       |   great 3D   |   8.9     |
#     |   2     | Science   |   fiction    |   8.5     |
#     |   3     | irish     |   boring     |   6.2     |
#     |   4     | Ice song  |   Fantacy    |   8.6     |
#     |   5     | House card|   Interesting|   9.1     |
#     +---------+-----------+--------------+-----------+
#     
# 
# For the example above, the output should be:
# 
#     
#     
#     +---------+-----------+--------------+-----------+
#     |   id    | movie     |  description |  rating   |
#     +---------+-----------+--------------+-----------+
#     |   5     | House card|   Interesting|   9.1     |
#     |   1     | War       |   great 3D   |   8.9     |
#     +---------+-----------+--------------+-----------+
#     
# 
# 
# 
# 
## @lc code=start
using LeetCode

## add your code here:
## @lc code=end
