SQL | HackerRank 삼각형 분류하기: 조건문 CASE를 활용한 다중 조건 처리
·
Computer Science/SQL
Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table:Equilateral: It's a triangle with sides of equal length.Isosceles: It's a triangle with sides of equal length.Scalene: It's a triangle with sides of differing lengths.Not A Triangle: The given values of A, B, and C don't for..
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' 태그의 글 목록 (3 Page)