SQL | LeetCode 1907. Salary 범주별 계좌 수 세기 (UNION vs. UNION ALL)
·
Computer Science/SQL
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..
SQL | LeetCode 1204. 버스 정원 제한에 따라 탈 수 있는 마지막 사람 구하기
·
Computer Science/SQL
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 ..
SQL | LeetCode 1164. 모든 제품의 가격 구하기
·
Computer Science/SQL
Table: Products+---------------+---------+| Column Name | Type |+---------------+---------+| product_id | int || new_price | int || change_date | date |+---------------+---------+(product_id, change_date) is the primary key (combination of columns with unique values) of this table.Each row of this table indicates that the price of some product was changed to a new price ..
SQL | LeetCode 1731. 매니저 정보 구하기
·
Computer Science/SQL
Table: Employees+-------------+----------+| Column Name | Type |+-------------+----------+| employee_id | int || name | varchar || reports_to | int || age | int |+-------------+----------+employee_id is the column with unique values for this table.This table contains information about the employees and the id of the manager they report to. Some employees do no..
SQL | LeetCode 619. Biggest Single Number (SQL GROUP BY...HAVING)
·
Computer Science/SQL
Table: MyNumbers+-------------+------+| Column Name | Type |+-------------+------+| num | int |+-------------+------+This table may contain duplicates (In other words, there is no primary key for this table in SQL).Each row of this table contains an integer. A single number is a number that appeared only once in the MyNumbers table.Find the largest single number. If there is no single n..
SQL | LeetCode 550. Game Play Analysis IV (SQL 서브쿼리 사용)
·
Computer Science/SQL
Table: Activity+--------------+---------+| Column Name | Type |+--------------+---------+| player_id | int || device_id | int || event_date | date || games_played | int |+--------------+---------+(player_id, event_date) is the primary key (combination of columns with unique values) of this table.This table shows the activity of players of some games.Each row is a recor..
올리브한입
'Computer Science/SQL' 카테고리의 글 목록 (5 Page)