오늘도 배운다

문제 source: LeetCode Write an SQL query to display the records with three or more rows with consecutive id's, and the number of people is greater than or equal to 100 for each. Return the result table ordered by visit_date in ascending order. 제출답안(MySQL) WITH std AS ( SELECT id, visit_date, people, id - ROW_NUMBER() OVER(ORDER BY id) AS row_num FROM stadium WHERE people >= 100 ), std_cons AS ( SE..

문제 source: HackerRank Harry Potter and his friends are at Ollivander's with Ron, finally replacing Charlie's old broken wand.Hermione decides the best way to choose is by determining the minimum number of gold galleons needed to buy each non-evil wand of high power and age. Write a query to print the id, age, coins_needed, and power of the wands that Ron's interested in, sorted in order of desce..