g0601_0700.s0620_not_boring_movies.script.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-kotlin Show documentation

Kotlin-based LeetCode algorithm problem solutions, regularly updated

There is a newer version: 1.30

# Write your MySQL query statement below
# #Easy #Database #2023_02_06_Time_305_ms_(59.80%)_Space_0B_(100.00%)
select id, movie, description, rating from Cinema
WHERE mod(id,2) = 1
and
description not LIKE '%boring%'
order by rating DESC;