본문 바로가기

SQL101

leetcode 1934. Confirmation Rate https://leetcode.com/problems/confirmation-rate/description/ Confirmation Rate - LeetCode Can you solve this real interview question? Confirmation Rate - Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +----------------+----------+ user_id is the prima leetcode.com 1 2 3 4 5 6 # Write your MySQL query s.. 2023. 4. 21.
leetcode 1661. Average Time of Process per Machine https://leetcode.com/problems/average-time-of-process-per-machine/description/ Average Time of Process per Machine - LeetCode Can you solve this real interview question? Average Time of Process per Machine - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 5 6 # Write your MySQL quer.. 2023. 4. 14.
leetcode 1068. Product Sales Analysis I https://leetcode.com/problems/product-sales-analysis-i/description/ Product Sales Analysis I - LeetCode Can you solve this real interview question? Product Sales Analysis I - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 5 # Write your MySQL query statement below select p.product_.. 2023. 4. 14.
leetcode 1280. Students and Examinations https://leetcode.com/problems/students-and-examinations/description/ Students and Examinations - LeetCode Can you solve this real interview question? Students and Examinations - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 5 6 7 8 9 10 11 12 # Write your MySQL query statement bel.. 2023. 4. 12.
leetcode 577. Employee Bonus https://leetcode.com/problems/employee-bonus/description/ Employee Bonus - LeetCode Can you solve this real interview question? Employee Bonus - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 5 6 # Write your MySQL query statement below select e.name, b.bonus from Employee e left j.. 2023. 4. 12.
leetcode 1327. List the Products Ordered in a Period https://leetcode.com/problems/list-the-products-ordered-in-a-period/description/ List the Products Ordered in a Period - LeetCode Can you solve this real interview question? List the Products Ordered in a Period - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 5 6 7 8 # Write your .. 2023. 4. 8.
leetcode 1789. Primary Department for Each Employee https://leetcode.com/problems/primary-department-for-each-employee/description/ Primary Department for Each Employee - LeetCode Can you solve this real interview question? Primary Department for Each Employee - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 5 6 7 8 9 # Write your M.. 2023. 4. 8.
leetcode 1251. Average Selling Price https://leetcode.com/problems/average-selling-price/description/ Average Selling Price - LeetCode Can you solve this real interview question? Average Selling Price - Table: Prices +---------------+---------+ | Column Name | Type | +---------------+---------+ | product_id | int | | start_date | date | | end_date | date | | price | int | +--------------- leetcode.com 1 2 3 4 5 6 7 # Write your MyS.. 2023. 4. 7.
leetcode 2356. Number of Unique Subjects Taught by Each Teacher https://leetcode.com/problems/number-of-unique-subjects-taught-by-each-teacher/description/ Number of Unique Subjects Taught by Each Teacher - LeetCode Can you solve this real interview question? Number of Unique Subjects Taught by Each Teacher - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode... 2023. 4. 6.
leetcode 1378. Replace Employee ID With The Unique Identifier https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier/description/ 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 | | name | varchar | +---------------+---------+ i.. 2023. 4. 6.
leetcode 1683. Invalid Tweets https://leetcode.com/problems/invalid-tweets/description/ Invalid Tweets - LeetCode Can you solve this real interview question? Invalid Tweets - Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 1 2 3 4 # Write your MySQL query statement below select tweet_id from Tweets where CHARACTER_LENGT.. 2023. 4. 6.
leetcode 1393. Capital Gain/Loss https://leetcode.com/problems/capital-gainloss/description/ Capital Gain/Loss - LeetCode Capital Gain/Loss - Table: Stocks +---------------+---------+ | Column Name | Type | +---------------+---------+ | stock_name | varchar | | operation | enum | | operation_day | int | | price | int | +---------------+---------+ (stock_name, operation_day) i leetcode.com 1 2 3 4 5 6 7 8 9 10 # Write your MySQL.. 2023. 1. 26.