ToDo_DATA

https://www.hackerrank.com/challenges/weather-observation-station-5 Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com with base as ( select city, length(city) len , dense_rank() over (order by length(city), city) rn1 , dense_rank() over (order by length(city) desc, city) rn2 from..

https://leetcode.com/problems/rising-temperature LeetCode - The World's Leading Online Programming Learning Platform 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 with base as ( select id, recordDate, temperature , lag(recordDate, 1) over (order by recordDate) last_d , lag(temperature, 1)..

https://leetcode.com/problems/exchange-seats Exchange Seats - LeetCode Can you solve this real interview question? Exchange Seats - Table: Seat +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | student | varchar | +-------------+---------+ id is the primary key (unique value) column for leetcode.com select case when id = (select max(id) from Seat) and id%2..

https://leetcode.com/problems/human-traffic-of-stadium LeetCode - The World's Leading Online Programming Learning Platform 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 with base as ( select distinct id, visit_date, people , id - row_number() over (order by id) as rn from Stadium where pe..

https://leetcode.com/problems/consecutive-numbers Consecutive Numbers - LeetCode Can you solve this real interview question? Consecutive Numbers - Table: Logs +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | num | varchar | +-------------+---------+ In SQL, id is the primary key for this table. leetcode.com with base as ( select num , lag(num, 1) over (or..

https://leetcode.com/problems/second-highest-salary Second Highest Salary - LeetCode Can you solve this real interview question? Second Highest Salary - Table: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | salary | int | +-------------+------+ id is the primary key (column with unique values) leetcode.com with base as( select distinct salary , dense..

https://school.programmers.co.kr/learn/courses/30/lessons/131537 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr with a as ( select sales_date , product_id , user_id , sum(sales_amount) as sales_amount from ONLINE_SALE where year(sales_date) = 2022 and month(sales_date) = 3 group by 1, 2, 3 ) , b as ( select sales_date , product_id ,..

https://school.programmers.co.kr/learn/courses/30/lessons/131530 프로그래머스 코드 중심의 개발자 채용. 스택 기반의 포지션 매칭. 프로그래머스의 개발자 맞춤형 프로필을 등록하고, 나와 기술 궁합이 잘 맞는 기업들을 매칭 받으세요. programmers.co.kr SELECT case when price < 10000 then 0 else (floor(price/10000)*10000) end as price_group , count(distinct product_id) products from product group by 1 order by 1