목록코딩테스트/SQL (24)
On the journey of
[Leetcode]1683.Invalid Tweets/577. Employee Bonus/1075. Project Employees 1/596. Classes More than 5 students
1683. Invalid Tweets https://leetcode.com/problems/invalid-tweets/ 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 Q. Write a solution to find the IDs..
[LeetCode]1661.Average Time of~, 1251.Average Selling Price , 1141. User Activity for the Past 30 Days I
Q. 1661 Average Time of Process per Machine Average Time of Process per Machine - LeetCode Can you solve this real interview question? Average Time of Process per Machine - Table: Activity +----------------+---------+ | Column Name | Type | +----------------+---------+ | machine_id | int | | process_id | int | | activity_type | enum | | timestam leetcode.com Table: Views +---------------+-------..
[LeetCode] 595.Big Countries,1068. Product Sales Analysis 1
Select_Big Countries Basic Joins_Customer Who Visited but Not Make Any Transactions Basic Joins_Rising Temperature Subqueries_Employees Whose Manager Left the Company 595. Big Countries https://leetcode.com/problems/big-countries/ (아래 첨부) Big Countries - LeetCode Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-----------..
[LEETCODE] SQL50 : 595.Big Countries,1148.Article Views 1
프로그래머스에 이어 다시! 리트코드 재개한다 ...... ! 아좌 (...) 1. Big Countries : https://leetcode.com/problems/big-countries/?envType=study-plan-v2&envId=top-sql-50 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 | ..