101
0/304
Loading content...
A content operations team maintains a Cinema catalog table:
Build the featured feed used by the homepage carousel.
Include only rows that satisfy both rules:
Return exactly these columns:
Ordering requirement:
Supported submissions:
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 |[
{"id":5,"movie":"House Card","description":"interesting","rating":9.1},
{"id":1,"movie":"War","description":"great 3D","rating":8.9}
]Odd IDs are 1, 3, and 5. Row 3 is excluded because description is exactly 'boring'. Remaining rows are sorted by rating descending.
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}
]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.
Cinema:
| id | movie | description | rating |
|----|--------------|-------------|--------|
| 2 | Orbital | intense | 9.8 |
| 4 | Valley Moon | calm | 7.1 |
| 6 | Core Signal | boring | 8.4 |[]All IDs are even, so no row can satisfy the odd-id requirement.
Constraints