Cinema Highlight Feed

Easy

A content operations team maintains a Cinema catalog table: id: unique movie record identifier movie: movie title description: short editorial tag for the movie rating: audience score in the range [0, 10] Build the featured feed used by the homepage carousel. Include only rows that satisfy both rules: id is odd description is not exactly the lowercase string 'boring' Return exactly these columns: id movie description rating Ordering requirement: sort by rating in descending order for deterministic evaluation in this version, break rating ties by id ascending Supported submissions: SQL (SQLite 3.27.2) Pandas (Python)

Example 1

Input

Cinema:
| id | movie       | description | rating |
|----|-------------|-------------|--------|
| 1  | War         | great 3D    | 8.9    |
| 2  | Science     | fiction     | 8.5    |
| 3  | Irish       | boring      | 6.2    |
| 4  | Ice Song    | fantasy     | 8.6    |
| 5  | House Card  | interesting | 9.1    |

Output

[
  {"id":5,"movie":"House Card","description":"interesting","rating":9.1},
  {"id":1,"movie":"War","description":"great 3D","rating":8.9}
]

Explanation

Odd IDs are 1, 3, and 5. Row 3 is excluded because description is exactly 'boring'. Remaining rows are sorted by rating descending.

Example 2

Input

Cinema:
| id | movie         | description | rating |
|----|---------------|-------------|--------|
| 7  | Neon Pulse    | Boring      | 8.2    |
| 9  | Delta Night   | boring      | 7.8    |
| 11 | Echo Drift    | atmospheric | 8.2    |
| 13 | River Code    | thrilling   | 9.0    |

Output

[
  {"id":13,"movie":"River Code","description":"thrilling","rating":9.0},
  {"id":7,"movie":"Neon Pulse","description":"Boring","rating":8.2},
  {"id":11,"movie":"Echo Drift","description":"atmospheric","rating":8.2}
]

Explanation

Filtering is case-sensitive: only exact lowercase 'boring' is excluded. IDs 7 and 11 share rating 8.2, so tie-break by id ascending gives 7 before 11.

Example 3

Input

Cinema:
| id | movie        | description | rating |
|----|--------------|-------------|--------|
| 2  | Orbital      | intense     | 9.8    |
| 4  | Valley Moon  | calm        | 7.1    |
| 6  | Core Signal  | boring      | 8.4    |

Output

[]

Explanation

All IDs are even, so no row can satisfy the odd-id requirement.

Constraints

1 <= number of rows in Cinema <= 100000
1 <= id <= 2147483647
id values are unique
movie is a non-empty string
description is a non-empty string
0 <= rating <= 10
rating can contain up to 2 decimal places
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return exactly [id, movie, description, rating]

Cinema: | id | movie | description | rating | |----|-------------|-------------|--------| | 1 | War | great 3D | 8.9 | | 2 | Science | fiction | 8.5 | | 3 | Irish | boring | 6.2 | | 4 | Ice Song | fantasy | 8.6 | | 5 | House Card | interesting | 9.1 |

Cinema: | id | movie | description | rating | |----|---------------|-------------|--------| | 7 | Neon Pulse | Boring | 8.2 | | 9 | Delta Night | boring | 7.8 | | 11 | Echo Drift | atmospheric | 8.2 | | 13 | River Code | thrilling | 9.0 |

[ {"id":13,"movie":"River Code","description":"thrilling","rating":9.0}, {"id":7,"movie":"Neon Pulse","description":"Boring","rating":8.2}, {"id":11,"movie":"Echo Drift","description":"atmospheric","rating":8.2} ]

Cinema: | id | movie | description | rating | |----|--------------|-------------|--------| | 2 | Orbital | intense | 9.8 | | 4 | Valley Moon | calm | 7.1 | | 6 | Core Signal | boring | 8.4 |