MYSQL DAYTHREE

SELECT employee_id 
FROM (
    SELECT  employee_id FROM employees
    union all #联合所有 包括重复的
    SELECT employee_id FROM salaries
) AS t#每个派生表都要有自己的别名
GROUP BY employee_id#按照employee进行分组
HAVING count(employee_id)=1#取并集中只出现一次的
ORDER BY employee_id

```sql
# Write your MySQL query statement below、
SELECT product_id, 'store1'store,store1 price
FROM products
WHERE store1 IS NOT NULL
UNION ALL 
SELECT product_id, 'store2'store,store2 price
FROM products
WHERE store2 IS NOT NULL
UNION ALL
SELECT product_id, 'store3'store, store3 price
FROM products
WHERE store3 IS NOT NULL

# Write your MySQL query statement below
SELECT id, 'Root' AS type
FROM tree
WHERE p_id IS NULL
UNION
SELECT id,'Leaf' AS type
FROM tree
WHERE 
    id NOT IN (
        SELECT DISTINCT
        p_id 
        FROM tree
        WHERE p_id IS NOT NULL
    )AND p_id IS NOT NULL
UNION
SELECT id, 'Inner' AS type
FROM tree
WHERE id IN (
    SELECT DISTINCT
    p_id
    FROM tree
    WHERE p_id IS NOT NULL
) AND p_id IS NOT NULL

```sql
SELECT (SELECT DISTINCT
    Salary AS SecondHighestSalary
FROM employee
ORDER BY Salary DESC
LIMIT 1 OFFSET 1) AS SecondHighestSalary