본문 바로가기

🌄SQL

[Tutorial] SQL BETWEEN 용법 BETWEEN expr [NOT] BETWEEN begin_expr AND end_expr; The BETWEEN operator is a logical operator that allows you to specify whether a value in a range or not. The BETWEEN operator is often used in the WHERE clause of the SELECT, UPDATE, and DELETE statements 1. 논리 연산자로 범위의 값을 지정해줄 때 사용한다. SELECT, UPDATE, DELETE 구문의 WHERE 절에서 주로 사용된다. The BETWEEN operator returns true if the value of the expr is gr.. 더보기
[문제풀이] Contest Leaderboard * 삽질 풀이과정을 담고 있습니다. 해커랭크 Contest Leaderboard Contest Leaderboard | HackerRank Generate the contest leaderboard. www.hackerrank.com You did such a great job helping Julia with her last coding contest challenge that she wants you to work on this one, too! The total score of a hacker is the sum of their maximum scores for all of the challenges. Write a query to print the hacker_id, name, and total .. 더보기
[SQL] 홀짝홀짝 또 까먹었어요. SQL 홀/짝수, DISTINCT 리트코드 leetcode.com/problems/not-boring-movies/ 문제풀이 X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descriptions. Please write a SQL query to output movies with an odd numbered ID and a description that is not 'boring'. Order the result by rating. 1. 영화의 id가 홀수인 경우만 출력 / 2. description이 boring이 아닌 것만 출력.. 더보기