728x90
https://leetcode.com/problems/not-boring-movies/
Not Boring Movies - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
[problem]
1. 홀수인경우
2. description 에 boring이 들어간 경우 제외
3. order by DESC 적용
[analysis]
1.where 절을 통한 조건 적용
--> 홀수인경우 id % 2 !=0 으로 나타낼 수 있음 / boring문자 제외도 !를 이용함
[solution]
728x90
'MS SQL > MS SQL : Leetcode' 카테고리의 다른 글
| SQL - 586. Customer Placing the Largest Number of Orders (select, count) (0) | 2022.04.26 |
|---|---|
| SQL - 511. Game Play Analysis I (min, group by) (0) | 2022.04.26 |
| SQL - 183. Customers Who Never Order (left join, where) (0) | 2022.04.26 |
| SQL - Leetcode 175. Combine Two Tables (left join) (0) | 2022.04.25 |
| SQL - Leetcode 182.duplicate-emails (group by, having) (0) | 2022.04.25 |