• Home
• com.github.javadev
• leetcode-in-java
• 1.27
• source code
• script.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

g1901_2000.s1965_employees_with_missing_information.script.sql Maven / Gradle / Ivy

# Write your MySQL query statement below
# #Easy #Database #SQL_I_Day_4_Union_and_Select #2022_05_22_Time_617_ms_(30.40%)_Space_0B_(100.00%)
select employee_id
from employees
where employee_id not in (select employee_id from salaries)
UNION
select employee_id
from salaries
where employee_id not in (select employee_id from Employees)
order by 1