[1777#_EASY] Product's Price for Each Store
·
SQL/LeetCode
보호되어 있는 글입니다.
[1757_EASY] Recyclable and Low Fat Products
·
SQL/LeetCode
Table: Products +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_id | int | | low_fats | enum | | recyclable | enum | +-------------+---------+ product_id is the primary key for this table. low_fats is an ENUM of type ('Y', 'N') where 'Y' means this product is low fat and 'N' means it is not. recyclable is an ENUM of types ('Y', 'N') where 'Y' means this produ..
[1212#_MEDIUM]Team Scores in Football Tournament
·
SQL/LeetCode
보호되어 있는 글입니다.
[1205#_MEDIUM] Monthly Transactions II
·
SQL/LeetCode
보호되어 있는 글입니다.
[1741_EASY] Find Total Time Spent by Each Employee
·
SQL/LeetCode
Table: Employees +-------------+------+ | Column Name | Type | +-------------+------+ | emp_id | int | | event_day | date | | in_time | int | | out_time | int | +-------------+------+ (emp_id, event_day, in_time) is the primary key of this table. The table shows the employees' entries and exits in an office. event_day is the day at which this event happened, in_time is the minute at which the em..
[1731#_EASY] The Number of Employees Which Report to Each Employee
·
SQL/LeetCode
보호되어 있는 글입니다.
[1729_EASY] Find Followers Count
·
SQL/LeetCode
SELECT user_id, COUNT(follower_id) AS followers_count FROM Followers GROUP BY user_id ORDER BY user_id​ Find Followers Count - LeetCode 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 Table: Followers +-------------+------+ | Column Name | Type | +-------------+------+ | user_id | int | | f..
[1204#_MEDIUM] Last Person to Fit in the Bus
·
SQL/LeetCode
보호되어 있는 글입니다.