코딩테스트/SQL - Leetcode (19) 썸네일형 리스트형 Leetcode SQL Medium 난이도 전부 해결! 지난 1월 10일, Leetocde SQL문제의 Easy난이도(물론 무료분...ㅎ)를 다 격파하고 기념 글을 짧게 포스팅했었다. [오늘은 어땠나요?] - Leetcode SQL Easy난이도 전부 해결! Leetcode SQL Easy난이도 전부 해결! 냉무... 는 좀 심심하니까. 24.01.10 Leetcode의 SQL 문제 중 EASY 난이도를 전부 풀었다. 아 물론 무료버전에서 제공되는 문제들만. 무료버전이어도 문제가 꽤나 많다. 한 50여 문제 정도는 되는 듯. 별 k-wien1589.tistory.com 그리고 본인의 게으름과 이런저런 핑계거리가 합쳐, 근 한달이 지난 오늘 24. 02. 06 Leetcode SQL Medium 난이도도 전부 해결! 물론 무료분이지만 양질의 문제가 꽤 많다. .. 1934. Confirmation Rate Table: Signups +----------------+----------+ | Column Name | Type | +----------------+----------+ | user_id | int | | time_stamp | datetime | +----------------+----------+ user_id is the column of unique values for this table. Each row contains information about the signup time for the user with ID user_id. Table: Confirmations +----------------+----------+ | Column Name | Type | +--------------.. 1907. Count Salary Categories Table: Accounts +-------------+------+ | Column Name | Type | +-------------+------+ | account_id | int | | income | int | +-------------+------+ account_id is the primary key (column with unique values) for this table. Each row contains information about the monthly income for one bank account. Write a solution to calculate the number of bank accounts for each salary category. The salary catego.. 1393. Capital Gain/Loss Table: Stocks +---------------+---------+ | Column Name | Type | +---------------+---------+ | stock_name | varchar | | operation | enum | | operation_day | int | | price | int | +---------------+---------+ (stock_name, operation_day) is the primary key (combination of columns with unique values) for this table. The operation column is an ENUM (category) of type ('Sell', 'Buy') Each row of this .. 1341. Movie Rating Table: Movies +---------------+---------+ | Column Name | Type | +---------------+---------+ | movie_id | int | | title | varchar | +---------------+---------+ movie_id is the primary key (column with unique values) for this table. title is the name of the movie. Table: Users +---------------+---------+ | Column Name | Type | +---------------+---------+ | user_id | int | | name | varchar | +----.. 1204. Last Person to Fit in the Bus Table: Queue +-------------+---------+ | Column Name | Type | +-------------+---------+ | person_id | int | | person_name | varchar | | weight | int | | turn | int | +-------------+---------+ person_id column contains unique values. This table has the information about all people waiting for a bus. The person_id and turn columns will contain all numbers from 1 to n, where n is the number of rows.. 1193. Monthly Transactions I 간만에 풀어본 SQL문제.. 요새 이래저래 바빠서 문제를 좀 못 풀었는데, 머리를 좀 식히고 싶기도 하고 SQL 감도 잃지 않기 위해 풀었다. 세상에... 머리 식히려고 SQL 문제를 푸는 날이 오게 될 줄이야... Table: Transactions +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | country | varchar | | state | enum | | amount | int | | trans_date | date | +---------------+---------+ id is the primary key of this table. The table has informat.. 1174. Immediate Food Delivery II Table: Delivery +-----------------------------+---------+ | Column Name | Type | +-----------------------------+---------+ | delivery_id | int | | customer_id | int | | order_date | date | | customer_pref_delivery_date | date | +-----------------------------+---------+ delivery_id is the column of unique values of this table. The table holds information about food delivery to customers that make.. 이전 1 2 3 다음