코딩테스트151 [리트코드/SQL] 20. User Activity for the Past 30 Days I (1141) 👉https://leetcode.com/problems/user-activity-for-the-past-30-days-i/?envType=study-plan&id=sql-i User Activity for the Past 30 Days 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 find the daily active user count for a period of 30 days ending 2.. 코딩테스트/리트코드 SQL 2022. 12. 18. [리트코드/SQL] 19. Sales Person (607) 👉https://leetcode.com/problems/sales-person/description/?envType=study-plan&id=sql-i Sales Person - 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 names of all the salespersons who did not have any orders related to the company with the .. 코딩테스트/리트코드 SQL 2022. 12. 18. [리트코드/SQL] 18. Rising Temperature (197) 👉https://leetcode.com/problems/rising-temperature/description/?envType=study-plan&id=sql-i Rising Temperature - 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 all dates' Id with higher temperatures compared to its previous dates (yesterday). 2.. 코딩테스트/리트코드 SQL 2022. 12. 18. [리트코드/SQL] 17. Article Views I (1148) 👉 https://leetcode.com/problems/article-views-i/description/?envType=study-plan&id=sql-i Article Views 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 find all the authors that viewed at least one of their own articles. 2) Return the result tabl.. 코딩테스트/리트코드 SQL 2022. 12. 18. [리트코드/SQL] 16. Customer Who Visited but Did Not Make Any Transactions (1581) 👉https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/description/?envType=study-plan&id=sql-i Customer Who Visited but Did Not Make Any Transactions - 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 IDs of t.. 코딩테스트/리트코드 SQL 2022. 12. 18. [리트코드/SQL] 15. Combine Two Tables (175) 👉https://42-snoopy.tistory.com/entry/%EB%A6%AC%ED%8A%B8%EC%BD%94%EB%93%9CSQL-14-Second-Highest-Salary-176 Second Highest Salary - 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 name, last name, city, and state of each person in .. 코딩테스트/리트코드 SQL 2022. 12. 18. [리트코드/SQL] 14. Second Highest Salary (176) 👉https://leetcode.com/problems/second-highest-salary/?envType=study-plan&id=sql-i Second Highest Salary - 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 second highest salary from the Employee table. If there is no second highest salary,.. 코딩테스트/리트코드 SQL 2022. 12. 16. [리트코드/SQL] 13. Tree node (608) 👉https://leetcode.com/problems/tree-node/description/?envType=study-plan&id=sql-i Tree Node - 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 type of each node in the tree. Each node in the tree can be one of three types: "Leaf": if the n.. 코딩테스트/리트코드 SQL 2022. 12. 16. [리트코드/SQL] 12. Rearrange Products Table (1795) 👉https://leetcode.com/problems/rearrange-products-table/description/?envType=study-plan&id=sql-i Rearrange Products Table - 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 rearrange the Products table so that each row has (product_id, store, price)... 코딩테스트/리트코드 SQL 2022. 12. 16. [리트코드/SQL] 11. Employees With Missing Information (1965) 👉https://leetcode.com/problems/employees-with-missing-information/?envType=study-plan&id=sql-i Employees With Missing Information - 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 IDs of all the employees with missing information. The inf.. 코딩테스트/리트코드 SQL 2022. 12. 16. [해커랭크/SQL] 6. Weather Observation Station 1 👉https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com 🤔 문제 분석 1) Query a list of CITY and STATE from the STATION table. 💡 풀이 SELECT CITY, STATE FROM STATION 코딩테스트/해커랭크 SQL 2022. 12. 11. [해커랭크/SQL] 5. Japanese Cities' Names 👉https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com 🤔 문제 분석 1) Query the names of all the Japanese cities in the CITY table. 2) The COUNTRYCODE for Japan is JPN. 💡 풀이 SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN" 코딩테스트/해커랭크 SQL 2022. 12. 11. 이전 1 ··· 4 5 6 7 8 9 10 ··· 13 다음