코딩 테스트/Leetcode - SQL3 Leetcode SQL 50 - 602. Friend Requests II: Who Has the Most Friends 문제 사이트: @leetcode Table: RequestAccepted +----------------+---------+ | Column Name | Type | +----------------+---------+ | requester_id | int | | accepter_id | int | | accept_date | date | +----------------+---------+ (requester_id, accepter_id) is the primary key (combination of columns with unique values) for this table. This table contains the ID of the user who sent the request, the ID of t.. 2024. 3. 23. Leetcode SQL 50 - 1070. Product Sales Analysis III 문제 사이트: @leetcode Table: Sales +-------------+-------+ | Column Name | Type | +-------------+-------+ | sale_id | int | | product_id | int | | year | int | | quantity | int | | price | int | +-------------+-------+ (sale_id, year) is the primary key (combination of columns with unique values) of this table. product_id is a foreign key (reference column) to Product table. Each row of this table s.. 2024. 3. 23. Leetcode SQL 50 - 1321. Restaurant Growth 문제 사이트: @leetcode Table: Customer +---------------+---------+ | Column Name | Type | +---------------+---------+ | customer_id | int | | name | varchar | | visited_on | date | | amount | int | +---------------+---------+ In SQL,(customer_id, visited_on) is the primary key for this table. This table contains data about customer transactions in a restaurant. visited_on is the date on which the cus.. 2024. 3. 23. 이전 1 다음