SQL | LeetCode 1327. 특정 월 기준 주문량 분석하기
·
Computer Science/SQL
Table: Products+------------------+---------+| Column Name | Type |+------------------+---------+| product_id | int || product_name | varchar || product_category | varchar |+------------------+---------+product_id is the primary key (column with unique values) for this table.This table contains data about the company's products. Table: Orders+---------------+---------+| Col..
SQL | LeetCode 1484. 날짜별로 팔린 제품들 정리하기 (GROUP BY + 정렬 + 문자열 조합)
·
Computer Science/SQL
Table Activities:+-------------+---------+| Column Name | Type |+-------------+---------+| sell_date | date || product | varchar |+-------------+---------+There is no primary key (column with unique values) for this table. It may contain duplicates.Each row of this table contains the product name and the date it was sold in a market. Write a solution to find for each date the number ..
SQL | LeetCode 176. 두 번째 최대값 구하기 (DENSE_RANK)
·
Computer Science/SQL
Table: Employee+-------------+------+| Column Name | Type |+-------------+------+| id | int || salary | int |+-------------+------+id is the primary key (column with unique values) for this table.Each row of this table contains information about the salary of an employee. Write a solution to find the second highest distinct salary from the Employee table. If there is no second hi..
SQL | LeetCode 1667. 이름 포맷 통일하기 (CONCAT, UPPER, LOWER)
·
Computer Science/SQL
Table: Users+----------------+---------+| Column Name | Type |+----------------+---------+| user_id | int || name | varchar |+----------------+---------+user_id is the primary key (column with unique values) for this table.This table contains the ID and the name of the user. The name consists of only lowercase and uppercase characters. Write a solution to fix the names..
SQL | LeetCode 185. DENSE_RANK()로 부서별 Top 3 급여자 구하기
·
Computer Science/SQL
Table: Employee+--------------+---------+| Column Name | Type |+--------------+---------+| id | int || name | varchar || salary | int || departmentId | int |+--------------+---------+id is the primary key (column with unique values) for this table.departmentId is a foreign key (reference column) of the ID from the Department table.Each row of this table in..
SQL | LeetCode 585. 중복된 투자값 & 유일한 위치 조건 만족하는 투자 합계 구하기
·
Computer Science/SQL
Table: Insurance+-------------+-------+| Column Name | Type |+-------------+-------+| pid | int || tiv_2015 | float || tiv_2016 | float || lat | float || lon | float |+-------------+-------+pid is the primary key (column with unique values) for this table.Each row of this table contains information about one policy where:pid is the policyholder's policy ID.tiv_20..
올리브한입
'leetcode' 태그의 글 목록