코딩(72)
-
[LeetCode] SQL 50 / MySQL / 577. Employee Bonus
문제 링크 https://leetcode.com/problems/employee-bonus/description/?envType=study-plan-v2&envId=top-sql-50 Employee Bonus - LeetCode Can you solve this real interview question? Employee Bonus - Table: Employee +-------------+---------+ | Column Name | Type | +-------------+---------+ | empId | int | | name | varchar | | supervisor | int | | salary | int | +-------------+---------+ empId leetcode.com..
2024.01.06 -
[LeetCode] SQL 50 / MySQL / 1661. Average Time of Process per Machine
문제 링크 https://leetcode.com/problems/average-time-of-process-per-machine/?envType=study-plan-v2&envId=top-sql-50 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 | ..
2024.01.06 -
[LeetCode] SQL 50 / MySQL / 197. Rising Temperature
문제 링크 https://leetcode.com/problems/rising-temperature/description/?envType=study-plan-v2&envId=top-sql-50 Rising Temperature - LeetCode Can you solve this real interview question? Rising Temperature - Table: Weather +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | recordDate | date | | temperature | int | +---------------+---------+ id is the co leet..
2024.01.06 -
[LeetCode] SQL 50 / ORACLE / 1581. Customer Who Visited But Did Not Make Any Transactions
문제링크 https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/description/?envType=study-plan-v2&envId=top-sql-50 Customer Who Visited but Did Not Make Any Transactions - LeetCode Can you solve this real interview question? Customer Who Visited but Did Not Make Any Transactions - Table: Visits +-------------+---------+ | Column Name | Type | +-------------+---------+ ..
2024.01.06 -
[LeetCode] SQL 50 / ORACLE / 1068. Product Sales Analysis 1
문제 링크 https://leetcode.com/problems/product-sales-analysis-i/?envType=study-plan-v2&envId=top-sql-50 Product Sales Analysis I - LeetCode Can you solve this real interview question? Product Sales Analysis I - Table: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | year | int | | quantity | int | | price | int | +----------- leet..
2024.01.06 -
[LeetCode] SQL 50 / Oracle / 1378. Replace Employee ID With The Unique Identifier
문제링크 https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/description/?envType=study-plan-v2&envId=top-sql-50 Replace Employee ID With The Unique Identifier - LeetCode Can you solve this real interview question? Replace Employee ID With The Unique Identifier - Table: Employees +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | na..
2024.01.06