코딩테스트/리트코드 SQL32

• [리트코드/SQL] 33. Sales Analysis III (1084) 👉https://leetcode.com/problems/sales-analysis-iii/description/ Sales Analysis III - LeetCode Can you solve this real interview question? Sales Analysis III - Table: Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | | unit_price | int | +--------------+---------+ pro leetcode.com 🤔 문제 분석 1) Write an SQL query that .. 코딩테스트/리트코드 SQL 2023. 2. 14.

• [리트코드/SQL] 32. Bank Account Summary II (1587) 👉https://leetcode.com/problems/bank-account-summary-ii/description/ Bank Account Summary II - LeetCode Bank Account Summary II - Table: Users +--------------+---------+ | Column Name | Type | +--------------+---------+ | account | int | | name | varchar | +--------------+---------+ account is the primary key for this table. Each row of this table contains t leetcode.com 🤔 문제 분석 1) Write an SQL q.. 코딩테스트/리트코드 SQL 2023. 2. 14.

• [리트코드/SQL] 31. Actors and Directors Who Cooperated At Least Three Times (1050) 👉https://leetcode.com/problems/actors-and-directors-who-cooperated-at-least-three-times/description/ Actors and Directors Who Cooperated At Least Three Times - LeetCode Actors and Directors Who Cooperated At Least Three Times - Table: ActorDirector +-------------+---------+ | Column Name | Type | +-------------+---------+ | actor_id | int | | director_id | int | | timestamp | int | +------------.. 코딩테스트/리트코드 SQL 2023. 2. 14.

• [리트코드/SQL] 30. Duplicate Emalis (182) 👉https://leetcode.com/problems/duplicate-emails/description/ 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 🤔 문제 분석 1) Write an SQL query to report all the duplicate emails. 2) Return the result table in any order. 💡 풀이 select Email FROM Person group by Email ha.. 코딩테스트/리트코드 SQL 2022. 12. 23.

• [리트코드/SQL] 28. Top Travellers (1407) 👉https://leetcode.com/problems/top-travellers/description/ 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 🤔 문제 분석 1) Return the result table ordered by travelled_distance in descending order, 2) if two or more users traveled the same distance, order them by .. 코딩테스트/리트코드 SQL 2022. 12. 23.

• [리트코드/SQL] 27. Capital Gain/Loss(1393) 👉https://leetcode.com/problems/capital-gainloss/description/ 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 🤔 문제 분석 1) Write an SQL query to report the Capital gain/loss for each stock. 2) The Capital gain/loss of a stock is the total gain or loss after buying .. 코딩테스트/리트코드 SQL 2022. 12. 21.

• [리트코드/SQL] 26. Find Total Time Spent by Each Employee (1741) 👉https://leetcode.com/problems/find-total-time-spent-by-each-employee/description/ Find Total Time Spent by Each Employee - 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 🤔 문제 분석 1) Write an SQL query to calculate the total time in minutes spent by each employee on each day at the.. 코딩테스트/리트코드 SQL 2022. 12. 21.

• [리트코드/SQL] 25. The Latest Login in 2020 (1890) 👉https://leetcode.com/problems/the-latest-login-in-2020/description/?envType=study-plan&id=sql-i The Latest Login in 2020 - 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 🤔 문제 분석 1) Write an SQL query to report the latest login for all users in the year 2020. 2) Do not include the.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 24. Game Play Analysis I (511) 👉 https://leetcode.com/problems/game-play-analysis-i/description/?envType=study-plan&id=sql-i Game Play 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 🤔 문제 분석 1) Write an SQL query to report the first login date for each player. 💡 풀이 SELECT player_id, min(event_date) .. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 23. Customer Placing the Largest Number of Orders (586) 👉https://leetcode.com/problems/customer-placing-the-largest-number-of-orders/description/?envType=study-plan&id=sql-i Customer Placing the Largest Number of Orders - 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 🤔 문제 분석 1) Write an SQL query to find the for the customer who has p.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 22. Find Followers Count (1729) 👉https://leetcode.com/problems/find-followers-count/?envType=study-plan&id=sql-i Find Followers Count - 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 🤔 문제 분석 1) Write an SQL query that will, for each user, return the number of followers. 2) Return the result table ordered by user.. 코딩테스트/리트코드 SQL 2022. 12. 18.

• [리트코드/SQL] 21. Daily Leads and Partners (1693) 👉https://leetcode.com/problems/daily-leads-and-partners/description/?envType=study-plan&id=sql-i Daily Leads and Partners - 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 🤔 문제 분석 1) Write an SQL query that will, for each date_id and make_name, return the number of distinct lead_id.. 코딩테스트/리트코드 SQL 2022. 12. 18.