본문 바로가기

Where절 서브쿼리

Hackerrank / Basic Join / Ollivander's Inventory / MySQL 2024. 1. 10. 10:29 📚문제 https://www.hackerrank.com/challenges/harry-potter-and-wands/problem?isFullScreen=true Ollivander's Inventory | HackerRank Help pick out Ron's new wand. www.hackerrank.com 📝풀이 SELECT w.id , p.age , w.coins_needed , w.power FROM Wands w INNER JOIN Wands_Property p ON w.code = p.code WHERE (p.age,w.power,w.coins_needed) IN (SELECT p.age AS age , w.power AS power , MIN(w.coins_needed) AS min_co..
LeetCode / 1084. Sales Analysis III / MySQL / Easy 2023. 12. 28. 18:50 📚문제 📝풀이 # Write your MySQL query statement below SELECT DISTINCT s.product_id , p.product_name FROM Sales s INNER JOIN Product p ON s.product_id = p.product_id WHERE s.sale_date BETWEEN '2019-01-01' AND '2019-03-31' AND s.product_id NOT IN (SELECT DISTINCT product_id FROM Sales WHERE sale_date NOT BETWEEN '2019-01-01' AND '2019-03-31') 처음에는 WHERE절 서브쿼리에서 계속 오답이 발생해서 WHERE sale_date > '2019-03-31..
SQL 고득점 Kit / GROUP BY / 대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기 / MySQL 2023. 10. 27. 14:44 📚문제 📝풀이 SELECT EXTRACT(MONTH FROM START_DATE) AS MONTH #MONTH(start_date) AS MONTH , CAR_ID , COUNT(*) RECORDS FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE EXTRACT(MONTH FROM START_DATE) IN (8,9,10) #WHERE DATE_FORMAT(start_date, "%Y-%m") BETWEEN '2022-08' AND '2022-10' AND CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE EXTRACT(MONTH FROM START_DATE) IN (8,9,10) GROUP BY C..
HackerRank / Basic Select / Weather Observation Station 5 / MySQL 2023. 10. 4. 20:34 📚문제 📝풀이 # shortest (SELECT CITY , LENGTH(CITY) FROM STATION ORDER BY LENGTH (CITY), CITY LIMIT 1) UNION # longest (SELECT CITY , LENGTH(CITY) FROM STATION ORDER BY LENGTH (CITY) DESC , CITY LIMIT 1) 1. LENGTH(column) 해당 컬럼에 있는 행들의 글자 수를 가져옴 파이썬과 비슷하기도하고 옛날에 배운 기억이 나서 활용 2. UNION SELECT문 2가지 합치는 방법이 생각 안나서 구글링 이것도 옛날에 배웠었던 것 같은데 흠 + PCSQL 시험 대비해서 블로그에 풀이 올려놓은 SQL 문제 다시 복습해보는 중이다 근데 이 문제는 오히려 더 어렵..

티스토리툴바