In der Ruhe

난이도: EASY 문제 링크: https://leetcode.com/problems/average-selling-price/description/?envType=study-plan-v2&envId=top-sql-50문제더보기Table: Prices+---------------+---------+ | Column Name   | Type    | +---------------+---------+ | product_id    | int     | | start_date    | date    | | end_date      | date    | | price         | int     | +---------------+---------+ (product_id, start_date, end_date) i..

난이도: EASY 문제 링크: https://leetcode.com/problems/not-boring-movies/description/?envType=study-plan-v2&envId=top-sql-50문제더보기Table: Cinema+----------------+----------+ | Column Name    | Type     | +----------------+----------+ | id             | int      | | movie          | varchar  | | description    | varchar  | | rating         | float    | +----------------+----------+ id is the primary key (c..

난이도: EASY 문제 링크: https://leetcode.com/problems/find-followers-count/?envType=study-plan-v2&envId=top-sql-50문제더보기Table: Followers+-------------+------+ | Column Name | Type | +-------------+------+ | user_id     | int  | | follower_id | int  | +-------------+------+(user_id, follower_id) is the primary key (combination of columns with unique values) for this table. This table contains the IDs of ..

난이도: EASY 문제 링크: https://leetcode.com/problems/classes-more-than-5-students/description/?envType=study-plan-v2&envId=top-sql-50문제더보기Table: Courses+-------------+---------+ | Column Name | Type    | +-------------+---------+ | student     | varchar | | class       | varchar | +-------------+---------+ (student, class) is the primary key (combination of columns with unique values) for this table. ..

난이도: EASY 문제 링크: https://leetcode.com/problems/user-activity-for-the-past-30-days-i/description/?envType=study-plan-v2&envId=top-sql-50문제더보기Table: Activity +---------------+---------+ | Column Name   | Type    | +---------------+---------+ | user_id       | int     | | session_id    | int     | | activity_date | date    | | activity_type | enum    | +---------------+---------+ This table may hav..

난이도: EASY 문제 링크: https://leetcode.com/problems/number-of-unique-subjects-taught-by-each-teacher/description/?envType=study-plan-v2&envId=top-sql-50문제더보기Table: Teacher+-------------+------+ | Column Name | Type | +-------------+------+ | teacher_id  | int  | | subject_id  | int  | | dept_id     | int  | +-------------+------+ (subject_id, dept_id) is the primary key (combinations of columns with ..