员工表要发给外部同事查看，需要去掉敏感信息。
email 和 salary 两列，其余所有列都保留。输入
employees(emp_id, name, dept_id, manager_id, hire_date, salary, title, email)（列的先后顺序因 case 而异）输出
列为 emp_id, name, dept_id, manager_id, hire_date, title，列顺序和行顺序都不限。
employees hr/employees
| # | emp_idint64 | namestring | dept_idint64 | manager_idint64 | hire_datedate | salaryint64 | titlestring | emailstring |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Grace Liu | 1 | null | 2015-10-01 | 98000 | CEO | grace.liu@corp.example |
| 2 | 2 | Leo Wang | 2 | 1 | 2017-09-09 | 72000 | VP Engineering | leo.wang@corp.example |
| 3 | 3 | Sara Chen | 3 | 1 | 2020-06-05 | 70000 | VP Sales | sara.chen@corp.example |
| 4 | 4 | Lucas Zhang | 4 | 2 | 2023-04-20 | 52000 | Engineering Manager | lucas.zhang@corp.example |
| 5 | 5 | Mia Zhao | 5 | 2 | 2016-07-16 | 52000 | Data Manager | mia.zhao@corp.example |
| 6 | 6 | Kevin Wu | 3 | 3 | 2016-10-23 | 45000 | Sales Manager | kevin.wu@corp.example |
| 7 | 7 | Lily Xu | 6 | 4 | 2025-03-17 | 48000 | Infra Lead | lily.xu@corp.example |
| 8 | 8 | Tom Huang | 4 | 4 | 2022-01-03 | 46000 | Senior Engineer | tom.huang@corp.example |
| 9 | 9 | Liam Zhou | 4 | 4 | 2020-10-01 | 39000 | Software Engineer | liam.zhou@corp.example |
| 10 | 10 | Nina Yang | 4 | 4 | 2020-10-02 | 39000 | Software Engineer | nina.yang@corp.example |
| 11 | 11 | Oscar Lin | 4 | 8 | 2022-07-15 | 26000 | Junior Engineer | oscar.lin@corp.example |
| 12 | 12 | Linda Ma | 5 | 5 | 2016-08-25 | 41000 | Data Engineer | linda.ma@corp.example |
| 13 | 13 | Eric Sun | 5 | 5 | 2021-09-09 | 33000 | Data Analyst | eric.sun@corp.example |
| 14 | 14 | Ivy He | 5 | 5 | 2018-05-29 | 41000 | Data Engineer | ivy.he@corp.example |
| 15 | 15 | Lei Gao | 5 | 12 | 2016-06-02 | 27000 | Junior Data Engineer | lei.gao@corp.example |
| 16 | 16 | Hao Guo | 6 | 7 | 2016-12-18 | 44000 | Site Reliability Engineer | hao.guo@corp.example |
| 17 | 17 | Fang Luo | 6 | 7 | 2020-11-11 | 38000 | Infra engineer | fang.luo@corp.example |
| 18 | 18 | Jun Liang | 6 | 16 | 2020-09-08 | 25000 | Junior Engineer | jun.liang@corp.example |
| 19 | 19 | Dana Song | 3 | 6 | 2016-10-13 | 31000 | Account Executive | dana.song@corp.example |
| 20 | 20 | Victor Tang | 3 | 6 | 2018-09-12 | 31000 | Account Executive | victor.tang@corp.example |
| # | emp_idInt64 | nameString | dept_idInt64 | manager_idInt64 | hire_dateDate | titleString |
|---|---|---|---|---|---|---|
| 1 | 1 | Grace Liu | 1 | null | 2015-10-01 | CEO |
| 2 | 2 | Leo Wang | 2 | 1 | 2017-09-09 | VP Engineering |
| 3 | 3 | Sara Chen | 3 | 1 | 2020-06-05 | VP Sales |
| 4 | 4 | Lucas Zhang | 4 | 2 | 2023-04-20 | Engineering Manager |
| 5 | 5 | Mia Zhao | 5 | 2 | 2016-07-16 | Data Manager |
| 6 | 6 | Kevin Wu | 3 | 3 | 2016-10-23 | Sales Manager |
| 7 | 7 | Lily Xu | 6 | 4 | 2025-03-17 | Infra Lead |
| 8 | 8 | Tom Huang | 4 | 4 | 2022-01-03 | Senior Engineer |
| 9 | 9 | Liam Zhou | 4 | 4 | 2020-10-01 | Software Engineer |
| 10 | 10 | Nina Yang | 4 | 4 | 2020-10-02 | Software Engineer |
| 11 | 11 | Oscar Lin | 4 | 8 | 2022-07-15 | Junior Engineer |
| 12 | 12 | Linda Ma | 5 | 5 | 2016-08-25 | Data Engineer |
| 13 | 13 | Eric Sun | 5 | 5 | 2021-09-09 | Data Analyst |
| 14 | 14 | Ivy He | 5 | 5 | 2018-05-29 | Data Engineer |
| 15 | 15 | Lei Gao | 5 | 12 | 2016-06-02 | Junior Data Engineer |
| 16 | 16 | Hao Guo | 6 | 7 | 2016-12-18 | Site Reliability Engineer |
| 17 | 17 | Fang Luo | 6 | 7 | 2020-11-11 | Infra engineer |
| 18 | 18 | Jun Liang | 6 | 16 | 2020-09-08 | Junior Engineer |
| 19 | 19 | Dana Song | 3 | 6 | 2016-10-13 | Account Executive |
| 20 | 20 | Victor Tang | 3 | 6 | 2018-09-12 | Account Executive |
| 21 | 21 | Wen Han | 3 | 6 | 2017-01-06 | Account Executive |
| 22 | 22 | Lu Feng | 3 | 6 | 2022-03-07 | Sales Engineer |
| 23 | 23 | Yan Deng | 3 | 21 | 2020-10-04 | Sales Intern |
| 24 | 24 | Zoe Cao | 7 | 1 | 2016-08-30 | General Counsel |
| 25 | 25 | Ping Peng | 4 | 8 | 2025-04-09 | Software Engineer |
| 26 | 26 | Qing Xie | 4 | 8 | 2022-05-05 | QA Engineer |
| 27 | 27 | Rui Lu | null | 3 | 2017-05-22 | Contractor |
| 28 | 28 | Uma Jiang | null | 2 | 2018-07-03 | Contractor |
| 29 | 29 | Xin Cai | 5 | 5 | 2023-01-27 | Data Scientist |
| 30 | 30 | Bob Pan | 4 | 4 | 2023-01-13 | Staff Engineer |
| 31 | 31 | Chen Du | 6 | 7 | 2022-07-15 | Infra Engineer |
| 32 | 32 | Amy Yu | 3 | 6 | 2016-09-10 | Account Manager |
| 33 | 33 | Larry Ren | 2 | 2 | 2022-06-21 | Engineering Director |
| 34 | 34 | Wei Shi | 5 | 12 | 2022-07-26 | Junior Data Analyst |
| 35 | 35 | Zhang Min | 4 | 8 | 2020-06-12 | Software Engineer |
| 36 | 36 | 王磊 | 3 | 6 | 2016-07-22 | Sales Rep |
| 37 | 37 | 李静 | 5 | 29 | 2024-02-29 | Research Assistant |
| 38 | 38 | Henry Kong | 6 | 16 | 2016-07-09 | Junior Engineer |
| 39 | 39 | Logan Bai | 4 | 30 | 2022-03-30 | Senior Engineer |
| 40 | 40 | Sophie Fan | 3 | 32 | 2025-08-17 | Sales Rep |