루루의 우당탕탕 개발 스토리 루루의 우당탕탕 개발 스토리

기본적인 subquery, group by, order by, join문 활용에는 더할나위없이 좋은 공부가 되었다.

https://leetcode.com/problems/sales-analysis-iii/ Sales Analysis III - 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 틀린 시도 select p.product_id, p.product_name from (select product_id, sale_date from sales where sale_date between '2019-01-01' and '2019-03-31') tb join product p on..

https://leetcode.com/problems/bank-account-summary-ii/?envType=study-plan&id=sql-i Bank Account Summary II - 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 select u.name, tb.sum as balance from (select account, sum(amount) as sum from Transactions group by account having sum(amoun..

https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/?envType=study-plan&id=sql-i Actors and Directors Who Cooperated At Least Three Times - 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 select actor_id, director_id from actordirector group by 1,..

https://leetcode.com/problems/duplicate-emails/?envType=study-plan&id=sql-i Duplicate Emails - 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 select email as Email from person group by email having count(id) >= 2;

https://leetcode.com/problems/market-analysis-i/ Market Analysis I - 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 select u.user_id as buyer_id, u.join_date, IFNULL(tb.number, 0) as orders_in_2019 from (select buyer_id, count(order_id) as number from orders where order_date betwe..

https://leetcode.com/problems/capital-gainloss/?envType=study-plan&id=sql-i Capital Gain/Loss - 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 select tb.stock_name, sum(price) as capital_gain_loss from (select stock_name, IF(operation = "Buy" , price*(-1), price) as price from sto..

https://leetcode.com/problems/top-travellers/?envType=study-plan&id=sql-i Top Travellers - 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 select u.name, IFNULL(tb.travelled_distance, 0) as travelled_distance from (select user_id, sum(distance) as travelled_distance from rides grou..