인동머스크

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..

Table: Sales+-------------+-------+| Column Name | Type |+-------------+-------+| sale_id | int || product_id | int || year | int || quantity | int || price | int |+-------------+-------+(sale_id, year) is the primary key (combination of columns with unique values) of this table.product_id is a foreign key (reference column) to Product table.Each row of this table..

Table: Logs+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || num | varchar |+-------------+---------+In SQL, id is the primary key for this table.id is an autoincrement column starting from 1. Find all numbers that appear at least three times consecutively.Return the result table in any order.The result format is in the following exampl..

Table: Employee+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || name | varchar || department | varchar || managerId | int |+-------------+---------+id is the primary key (column with unique values) for this table.Each row of this table indicates the name of an employee, their department, and the id of their manager.If managerId i..

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..

Table: Delivery+-----------------------------+---------+| Column Name | Type |+-----------------------------+---------+| delivery_id | int || customer_id | int || order_date | date || customer_pref_delivery_date | date |+-----------------------------+---------+delivery_id is the column of unique values of this tabl..

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 columns) of the ID from the Department table.Each row of this table i..

Table: Customer+---------------+---------+| Column Name | Type |+---------------+---------+| customer_id | int || name | varchar || visited_on | date || amount | int |+---------------+---------+In SQL,(customer_id, visited_on) is the primary key for this table.This table contains data about customer transactions in a restaurant.visited_on is the date on which..

Table: Products+---------------+---------+| Column Name | Type |+---------------+---------+| product_id | int || new_price | int || change_date | date |+---------------+---------+(product_id, change_date) is the primary key (combination of columns with unique values) of this table.Each row of this table indicates that the price of some product was changed to a new price ..

Table: Users+----------------+---------+| Column Name | Type |+----------------+---------+| user_id | int || join_date | date || favorite_brand | varchar |+----------------+---------+user_id is the primary key (column with unique values) of this table.This table has the info of the users of an online shopping website where users can sell and buy items. Table: Orders+----..