SQL (41) 썸네일형 리스트형 (SQL) - LeetCode (easy) 1280. Students and Examinations https://leetcode.com/problems/students-and-examinations/description/ Students and Examinations - LeetCode Can you solve this real interview question? Students and Examinations - Table: Students +---------------+---------+ | Column Name | Type | +---------------+---------+ | student_id | int | | student_name | varchar | +---------------+---------+ student_id is leetcode.com cross join, left join을.. (SQL) - LeetCode (easy) 1179. Reformat Department Table https://leetcode.com/problems/reformat-department-table/description/ Reformat Department Table - LeetCode Can you solve this real interview question? Reformat Department Table - Table: Department +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | revenue | int | | month | varchar | +-------------+---------+ In SQL,(id, mo leetcode.com 집계함수와 CASE WHEN 절을 사용해.. (SQL) - LeetCode (easy) 1084. Sales Analysis III https://leetcode.com/problems/sales-analysis-iii/description/ Sales Analysis III - LeetCode Can you solve this real interview question? Sales Analysis III - Table: Product +--------------+---------+ | Column Name | Type | +--------------+---------+ | product_id | int | | product_name | varchar | | unit_price | int | +--------------+---------+ pro leetcode.com join과 group by를 사용해본 문제였습니다. 📕 풀이방법 .. (SQL) - LeetCode (easy) 1075. Project Employees I https://leetcode.com/problems/project-employees-i/description/ Project Employees I - LeetCode Can you solve this real interview question? Project Employees I - Table: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +-------------+---------+ (project_id, employee_id) is th leetcode.com 집계함수와 join을 사용해보는 문제였습니다. 📕 풀이방법 📔.. (SQL) - LeetCode (easy) 627. Swap Salary https://leetcode.com/problems/swap-salary/description/ Swap Salary - LeetCode Can you solve this real interview question? Swap Salary - Table: Salary +-------------+----------+ | Column Name | Type | +-------------+----------+ | id | int | | name | varchar | | sex | ENUM | | salary | int | +-------------+----------+ id is the primar leetcode.com update문에 case when절을 사용해본 문제였습니다. 📕 풀이방법 📔 풀이과정 성별.. (SQL) - LeetCode (easy) 619. Biggest Single Number https://leetcode.com/problems/biggest-single-number/description/ Biggest Single Number - LeetCode Can you solve this real interview question? Biggest Single Number - Table: MyNumbers +-------------+------+ | Column Name | Type | +-------------+------+ | num | int | +-------------+------+ There is no primary key for this table. It may contain duplicates leetcode.com group by와 sub query를 사용해본 문제였습.. (SQL) - LeetCode (easy) 595. Big Countries https://leetcode.com/problems/big-countries/description/ Big Countries - LeetCode Can you solve this real interview question? Big Countries - Table: World +-------------+---------+ | Column Name | Type | +-------------+---------+ | name | varchar | | continent | varchar | | area | int | | population | int | | gdp | bigint | +----------- leetcode.com where을 사용해본 문제였습니다. 📕 풀이방법 📔 풀이과정 정해진 조건에 해당하는.. (SQL) - LeetCode (easy) 584. Find Customer Referee https://leetcode.com/problems/find-customer-referee/description/ Find Customer Referee - LeetCode Can you solve this real interview question? Find Customer Referee - Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +-------------+---------+ id is the primary leetcode.com select from where절을 사용해보는 기본 문제.. 이전 1 2 3 4 5 6 다음