Leetcode20 [leetcode] 177. Nth Highest Salary / SET 177. Nth Highest Salary https://leetcode.com/problems/nth-highest-salary/ Nth Highest Salary - LeetCode Can you solve this real interview question? Nth Highest Salary - Table: Employee +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | salary | int | +-------------+------+ id is the primary key column for this table. Each row leetcode.com Write an SQL query to re.. 2023. 1. 6. [leetcode] 1158. Market Analysis I / CASE WHEN, IFNULL 1158. Market Analysis I https://leetcode.com/problems/market-analysis-i/ Market Analysis I - LeetCode Can you solve this real interview question? Market Analysis I - Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | join_date | date | | favorite_brand | varchar | +----------------+---------+ u leetcode.com Write an SQL query to find.. 2022. 12. 30. [leetcode] 1667. Fix Names in a Table / CONCAT, SUBSTRING 1667. Fix Names in a Table https://leetcode.com/problems/fix-names-in-a-table/ Fix Names in a Table - LeetCode Can you solve this real interview question? Fix Names in a Table - Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+---------+ user_id is the primary key fo leetcode.com Write an SQL quer.. 2022. 12. 12. [leetcode] 608. Tree Node 608. Tree Node https://leetcode.com/problems/tree-node/ Tree Node - LeetCode Can you solve this real interview question? Tree Node - Table: Tree +-------------+------+ | Column Name | Type | +-------------+------+ | id | int | | p_id | int | +-------------+------+ id is the primary key column for this table. Each row of this table leetcode.com Each node in the tree can be one of three types: "Le.. 2022. 11. 29. [leetcode] 1141. User Activity for the Past 30 Days I / DATE_ADD, DATEDIFF https://leetcode.com/problems/user-activity-for-the-past-30-days-i/ User Activity for the Past 30 Days I - LeetCode Can you solve this real interview question? User Activity for the Past 30 Days I - Table: Activity +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | session_id | int | | activity_date | date | | activity_typ leetcode.com Write an SQL.. 2022. 11. 18. [Leetcode] 185. Department Top Three Salaries / 그룹별 TOP3 순위 구하기/DENSE_RANK https://leetcode.com/problems/department-top-three-salaries/ Department Top Three Salaries - LeetCode Can you solve this real interview question? Department Top Three Salaries - Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId | int | +-------------- leetcode.com 185. Department Top Three .. 2022. 11. 7. 이전 1 2 3 4 다음