Employees With Missing Information
<p>Table: <code>Employees</code></p>

<pre>
+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| employee_id | int     |
| name        | varchar |
+-------------+---------+
employee_id is the column with unique values for this table.
Each row of this table indicates the name of the employee whose ID is employee_id.
</pre>

<p>&nbsp;</p>

<p>Table: <code>Salaries</code></p>

<pre>
+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| employee_id | int     |
| salary      | int     |
+-------------+---------+
employee_id is the column with unique values for this table.
Each row of this table indicates the salary of the employee whose ID is employee_id.
</pre>

<p>&nbsp;</p>

<p>Write a solution to report the IDs of all the employees with <strong>missing information</strong>. The information of an employee is missing if:</p>

<ul>
	<li>The employee&#39;s <strong>name</strong> is missing, or</li>
	<li>The employee&#39;s <strong>salary</strong> is missing.</li>
</ul>

<p>Return the result table ordered by <code>employee_id</code> <strong>in ascending order</strong>.</p>

<p>The result format is in the following example.</p>

<p>&nbsp;</p>
<p><strong class="example">Example 1:</strong></p>

<pre>
<strong>Input:</strong> 
Employees table:
+-------------+----------+
| employee_id | name     |
+-------------+----------+
| 2           | Crew     |
| 4           | Haven    |
| 5           | Kristian |
+-------------+----------+
Salaries table:
+-------------+--------+
| employee_id | salary |
+-------------+--------+
| 5           | 76071  |
| 1           | 22517  |
| 4           | 63539  |
+-------------+--------+
<strong>Output:</strong> 
+-------------+
| employee_id |
+-------------+
| 1           |
| 2           |
+-------------+
<strong>Explanation:</strong> 
Employees 1, 2, 4, and 5 are working at this company.
The name of employee 1 is missing.
The salary of employee 2 is missing.
</pre>

[]
['Create table If Not Exists Employees (employee_id int, name varchar(30))', 'Create table If Not Exists Salaries (employee_id int, salary int)', 'Truncate table Employees', "insert into Employees (employee_id, name) values ('2', 'Crew')", "insert into Employees (employee_id, name) values ('4', 'Haven')", "insert into Employees (employee_id, name) values ('5', 'Kristian')", 'Truncate table Salaries', "insert into Salaries (employee_id, salary) values ('5', '76071')", "insert into Salaries (employee_id, salary) values ('1', '22517')", "insert into Salaries (employee_id, salary) values ('4', '63539')"]
[{"value": "mysql", "text": "MySQL", "defaultCode": "# Write your MySQL query statement below\n"}, {"value": "mssql", "text": "MS SQL Server", "defaultCode": "/* Write your T-SQL query statement below */\n"}, {"value": "oraclesql", "text": "Oracle", "defaultCode": "/* Write your PL/SQL query statement below */\n"}, {"value": "pythondata", "text": "Pandas", "defaultCode": "import pandas as pd\n\ndef find_employees(employees: pd.DataFrame, salaries: pd.DataFrame) -> pd.DataFrame:\n    "}, {"value": "postgresql", "text": "PostgreSQL", "defaultCode": "-- Write your PostgreSQL query statement below\n"}]
{"mysql": ["Create table If Not Exists Employees (employee_id int, name varchar(30))", "Create table If Not Exists Salaries (employee_id int, salary int)"], "mssql": ["Create table Employees (employee_id int, name varchar(30))", "Create table Salaries (employee_id int, salary int)"], "oraclesql": ["Create table Employees (employee_id int, name varchar(30))", "Create table Salaries (employee_id int, salary int)"], "database": true, "name": "find_employees", "pythondata": ["Employees = pd.DataFrame([], columns=['employee_id', 'name']).astype({'employee_id':'Int64', 'name':'object'})", "Salaries = pd.DataFrame([], columns=['employee_id', 'salary']).astype({'employee_id':'Int64', 'salary':'Int64'})"], "postgresql": ["Create table If Not Exists Employees (employee_id int, name varchar(30))", "Create table If Not Exists Salaries (employee_id int, salary int)"], "database_schema": {"Employees": {"employee_id": "INT", "name": "VARCHAR(30)"}, "Salaries": {"employee_id": "INT", "salary": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']