전체 글74 Rising Temperature 문제더보기Table: Weather+---------------+---------+| Column Name | Type |+---------------+---------+| id | int || recordDate | date || temperature | int |+---------------+---------+id is the column with unique values for this table.There are no different rows with the same recordDate.This table contains information about the temperature on a certain day. Write a soluti.. 2025. 3. 14. [MySQL] 176. Second Highest Salary 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.. 2025. 3. 13. 197. Rising Temperature Table: Weather+---------------+---------+| Column Name | Type |+---------------+---------+| id | int || recordDate | date || temperature | int |+---------------+---------+id is the column with unique values for this table.There are no different rows with the same recordDate.This table contains information about the temperature on a certain day. Write a solution to.. 2025. 3. 13. 584. Find Customer Referee Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | name | varchar | | referee_id | int | +-------------+---------+In SQL, id is the primary key column for this table. Each row of this table indicates the id of a customer, their name, and the id of the customer who referred them. Find the names of the customer th.. 2025. 3. 13. 181. Employees Earning More Than Their Managers Table: Employee+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar || salary | int || managerId | int |+-------------+---------+id is the primary key (column with unique values) for this table.Each row of this table indicates the ID of an employee, their name, salary, and the ID of their manager. Write a solut.. 2025. 3. 12. 176. Second Highest Salary 문제 : 표에서 두 번째로 높은 고유한 급여를 찾는 솔루션을 작성해라 employee. 두 번째로 높은 급여가 없으면 null(return None in Pandas) 을 반환한다. 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.. 2025. 3. 12. 이전 1 2 3 4 ··· 13 다음