SQL leetcode Not Boring Movies MYSQL SQL mod function

Write a query to retrieve movies with odd-numbered IDs and descriptions that are not labeled as "boring" from the Cinema table. Arrange the result table in descending order based on rating.

The Cinema table has the following schema:

sql
Copy code
+----------------+----------+
| Column Name | Type |
+----------------+----------+
| id | int |
| movie | varchar |
| description | varchar |
| rating | float |
+----------------+----------+
The id column is the primary key with unique values, and each row provides details about a movie's title, genre, and rating. The rating is a float value with two decimal places, ranging from 0 to 10.

SQL MySQL leetcode problem solution with mod function