전체 글 (26) 썸네일형 리스트형 Count Salary Categories - 수치를 그룹화해 등급으로 나누기 Count Salary Categories - LeetCode Count Salary Categories - LeetCode Can you solve this real interview question? Count Salary Categories - Table: Accounts +-------------+------+ | Column Name | Type | +-------------+------+ | account_id | int | | income | int | +-------------+------+ account_id is the primary key (column wi leetcode.com [ 연봉값들을 그룹화해 등급으로 나누기 ] Write a solution to calculate the .. Swap Salary - 칼럼값 바꾸기 Swap Salary - LeetCode 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 [칼럼값 바꾸기] Write a solution to swap all 'f' and 'm' values (i.e., change all 'f' va.. Not Boring Movies- where조건절 Not Boring Movies - LeetCode Not Boring Movies - LeetCode Can you solve this real interview question? Not Boring Movies - Table: Cinema +----------------+----------+ | Column Name | Type | +----------------+----------+ | id | int | | movie | varchar | | description | varchar | | rating | float | +---------------- leetcode.com Write a solution to report the movies with an odd-numbered ID and a de.. Biggest Single Number - (한 개의 칼럼만 있을 때) 중복값이 없는 숫자중 (=single number) 가장 큰 숫자를 찾아라 Biggest Single Number - LeetCode Biggest Single Number - LeetCode Can you solve this real interview question? Biggest Single Number - Table: MyNumbers +-------------+------+ | Column Name | Type | +-------------+------+ | num | int | +-------------+------+ This table may contain duplicates (In other words, there is no pr leetcode.com [한개의 칼럼만 있을 때 중복값이 없는 숫자중 (=single number) 가장 큰 숫자를 찾아라] Table.. Sales Person - 3개의 테이블 연결하여 값 찾기 Sales Person - LeetCode Sales Person - LeetCode Can you solve this real interview question? Sales Person - Table: SalesPerson +-----------------+---------+ | Column Name | Type | +-----------------+---------+ | sales_id | int | | name | varchar | | salary | int | | commission_rate | int | | hire_date | leetcode.com [3개의 테이블 연결하여 값 찾기] Write a solution to find the names of all the salespersons wh.. Customer Placing the Largest Number of Orders-가장 주문 많이 한 고객 찾기 Customer Placing the Largest Number of Orders - LeetCode Customer Placing the Largest Number of Orders - LeetCode Can you solve this real interview question? Customer Placing the Largest Number of Orders - Table: Orders +-----------------+----------+ | Column Name | Type | +-----------------+----------+ | order_number | int | | customer_number | int | +--------------- leetcode.com [가장 주문 많이 한 고객.. Delete Duplicate Emails - 중복된 이메일 지우기 Delete Duplicate Emails - LeetCode Delete Duplicate Emails - LeetCode Can you solve this real interview question? Delete Duplicate Emails - Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key (column with uni leetcode.com [중복된 이메일 지우기] Table: Person +-------------+---------+ | Co.. Department Highest Salary - 부서별 가장 연봉 높은 사람 구하기 Department Highest Salary - LeetCode Department Highest Salary - LeetCode Can you solve this real interview question? Department Highest Salary - Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | name | varchar | | salary | int | | departmentId | int | +--------------+--- leetcode.com [부서별 가장 연봉 높은 사람 구하기] Table: Employee +--------------+.. 이전 1 2 3 4 다음
