Leetcode SQL: Not Boring Movies #leetcode #sql

preview_player
Показать описание
Leetcode SQL for question 620 - Not Boring Movies

This SQL query helps you find and sort interesting movies from a cinema database by:

- Selecting all movie details from the Cinema table.
- Filtering out movies described as 'boring'.
- Including only movies with odd IDs.
- Sorting the movies by their rating from highest to lowest.

select *
from Cinema
where description != 'boring'
and id % 2 != 0
order by rating desc
Рекомендации по теме