전체 글(268)
-
[LeetCode] SQL 50 / MySQL / 1280. Students and Examinations
문제 링크 https://leetcode.com/problems/students-and-examinations/description/?envType=study-plan-v2&envId=top-sql-50 Students and Examinations - LeetCode Can you solve this real interview question? Students and Examinations - Table: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name | varchar | +---------------+---------+ stud..
2024.01.06 -
[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