#98. [LeetCode / MySQL] 1141. User Activity for the Past 30 Days I

문제 입력 코드 SELECT activity_date AS day, COUNT(DISTINCT user_id) AS active_users FROM Activity WHERE (activity_date > "2019-06-27" AND activity_date

• format_list_bulleted SQL
• · 2023. 9. 24.
• textsms

#85. [LeetCode / MySQL] 577. Employee Bonus

문제 입력 코드 SELECT E.name, B.bonus FROM Employee AS E LEFT JOIN Bonus AS B USING (empID) WHERE (B.bonus < 1000) OR (B.bonus IS NULL) 코드 설명 #SELECT #LEFT JOIN #JOIN #USING #WHERE #NULL 문제 출처 Employee Bonus - LeetCode Can you solve this real interview question? Employee Bonus - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | empId | int | | name | varchar ..

• format_list_bulleted SQL
• · 2023. 9. 11.
• textsms

#81. [LeetCode / MySQL] 1068. Product Sales Analysis I

문제 입력 코드 1. SELECT P.product_name, S.year, S.price FROM Sales AS S LEFT JOIN Product AS P ON S.product_id = P.product_id 2. SELECT P.product_name, S.year, S.price FROM Sales AS S, Product AS P WHERE S.product_id = P.product_id 3. SELECT P.product_name, S.year, S.price FROM Sales AS S JOIN Product AS P USING (product_id) 코드 설명 #SELECT #JOIN #LEFT JOIN #WHERE #USING 문제 출처 Product Sales Analysis I ..

• format_list_bulleted SQL
• · 2023. 9. 7.
• textsms

#79. [LeetCode / MySQL] 1683. Invalid Tweets

문제 입력 코드 SELECT tweet_id FROM Tweets WHERE LENGTH(content) > 15 코드 설명 #SELECT #WHERE #LENGTH 문제 출처 Invalid Tweets - LeetCode Can you solve this real interview question? Invalid Tweets - Table: Tweets +----------------+---------+ | Column Name | Type | +----------------+---------+ | tweet_id | int | | content | varchar | +----------------+---------+ tweet_id is the primary key (c leetcode.com

• format_list_bulleted SQL
• · 2023. 9. 5.
• textsms

#78. [LeetCode / MySQL] 1148. Article Views I

문제 → 자신의 기사 중 적어도 하나의 기사를 본 작가를 찾는 문제 (author_id = viewer_id가 같은 행을 찾는 문제) 입력 코드 SELECT DISTINCT author_id AS id FROM Views WHERE author_id = viewer_id ORDER BY id ASC 코드 설명 #SELECT #DISTINCT #WHERE #ORDER BY 문제 출처 Article Views I - LeetCode Can you solve this real interview question? Article Views I - Table: Views +---------------+---------+ | Column Name | Type | +---------------+---------+ | ..

• format_list_bulleted SQL
• · 2023. 9. 4.
• textsms

#77. [LeetCode / MySQL] 595. Big Countries

문제 입력 코드 SELECT name, population, area FROM World WHERE area >= 3000000 OR population >= 25000000 코드 설명 #SELECT #WHERE #OR 문제 출처 Big Countries - LeetCode Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area | int | | population | int | | gdp | bigint | ..

• format_list_bulleted SQL
• · 2023. 9. 3.
• textsms