# $1378. 使用唯一标识码替换员工ID
# https://leetcode-cn.com/problems/replace-employee-id-with-the-unique-identifier/

# SQL架构
Create table If Not Exists Employees (id int, name varchar(20));
Create table If Not Exists EmployeeUNI (id int, unique_id int);
Truncate table Employees;
insert into Employees (id, name) values ('1', 'Alice');
insert into Employees (id, name) values ('7', 'Bob');
insert into Employees (id, name) values ('11', 'Meir');
insert into Employees (id, name) values ('90', 'Winston');
insert into Employees (id, name) values ('3', 'Jonathan');
Truncate table EmployeeUNI;
insert into EmployeeUNI (id, unique_id) values ('3', '1');
insert into EmployeeUNI (id, unique_id) values ('11', '2');
insert into EmployeeUNI (id, unique_id) values ('90', '3');

# Write your MySQL query statement below
select
    eu.unique_id,
    es.name
from
    Employees es
    left join EmployeeUNI eu on es.id = eu.id;

# clean-up
drop table Employees;
drop table EmployeeUNI;