## 面试题

| Position table                   |                                  |                    |                    |
| -------------------------------- | -------------------------------- | ------------------ | ------------------ |
| company_id                       | people_id                        | start_date         | end_date           |
| 2a0a0700a3cf1c40a45c92839694390f | cdab114a8710180dbafc1f61e4980a62 | 2019-04-30 0:00:00 | null               |
| 2a0a0700a3cf1c40a45c92839694390f | 9bdc35b14a5cbebfb4d6a3167ab5d6a2 | 2019-04-30 0:00:00 | null               |
| 2a0a0700a3cf1c40a45c92839694390f | 9da257186d8f76a21d531d0a565a4ecf | 2019-04-30 0:00:00 | null               |
| 2a0a0700a3cf1c40a45c92839694390f | 33a7d11fc538b5314154b99b2d09361e | 2019-04-30 0:00:00 | null               |
| 2a0a0700a3cf1c40a45c92839694390f | d220601176d02766f20094ec47fb7e98 | 2019-04-30 0:00:00 | null               |
| 2a0a0700a3cf1c40a45c92839694390f | dbfd5a2b5c7d7a184f0a7cd43a70b2db | 2019-04-30 0:00:00 | null               |
| 8a507c27a1d64dd429c919e424031a51 | 51fb80e9410e8b10baad7f98013fd5c6 | 2017-09-25 0:00:00 | 2019-09-24 0:00:00 |
| 8a507c27a1d64dd429c919e424031a51 | 9de35bedd084cbb7cb60df1902515b08 | 2017-09-25 0:00:00 | 2019-09-24 0:00:00 |
| 8a507c27a1d64dd429c919e424031a51 | fd86bc39627f18ec98842c2afb9f317a | 2017-09-25 0:00:00 | 2019-09-24 0:00:00 |
| 8a507c27a1d64dd429c919e424031a51 | bd72d1d6bd9d47505bfa22ef61d96ded | 2017-09-25 0:00:00 | 2020-09-24 0:00:00 |
| 8a507c27a1d64dd429c919e424031a51 | b4cbd8418939c862e97c769e7a8fd60e | 2017-09-25 0:00:00 | 2020-09-24 0:00:00 |
| 8a507c27a1d64dd429c919e424031a51 | 72cfb720b6b6fe1d0101b131a2ecf198 | 2017-09-25 0:00:00 | 2020-09-24 0:00:00 |
| 8a507c27a1d64dd429c919e424031a51 | fe9e348160edbdcc4363a2f9f4de87f3 | 2017-09-25 0:00:00 | 2020-09-24 0:00:00 |

| People Table                     |             |        |
| -------------------------------- | ----------- | ------ |
| people_id                        | people_name | gender |
| cdab114a8710180dbafc1f61e4980a62 | 孙鹏        | MALE   |
| 9bdc35b14a5cbebfb4d6a3167ab5d6a2 | 董艳        | FEMALE |
| 9da257186d8f76a21d531d0a565a4ecf | 刘鸿玲      | FEMALE |
| 33a7d11fc538b5314154b99b2d09361e | 黄智锋      | MALE   |
| d220601176d02766f20094ec47fb7e98 | 陈方汉      | FEMALE |
| dbfd5a2b5c7d7a184f0a7cd43a70b2db | 王辅        | MALE   |
| 51fb80e9410e8b10baad7f98013fd5c6 | 孙颖        | FEMALE |
| 9de35bedd084cbb7cb60df1902515b08 | 胥雪瑾      | FEMALE |
| fd86bc39627f18ec98842c2afb9f317a | 沈岚        | FEMALE |
| bd72d1d6bd9d47505bfa22ef61d96ded | 龚佩        | FEMALE |
| b4cbd8418939c862e97c769e7a8fd60e | 郝妍燕      | FEMALE |
| 72cfb720b6b6fe1d0101b131a2ecf198 | 张来娣      | FEMALE |
| fe9e348160edbdcc4363a2f9f4de87f3 | 曹建成      | MALE   |

### 计算每家公司所有时间内的女性员工占比

| Question 1 sample 输出           |            |
| -------------------------------- | ---------- |
| company_id                       | female_pct |
| 2a0a0700a3cf1c40a45c92839694390f | 0.5        |
| 8a507c27a1d64dd429c919e424031a51 | 0.875      |

### 计算每家公司每年的女性员工占比（当年是否在职条件: 任职区间是否包含该年最后一天）

| Question 2 sample 输出           |      |            |
| -------------------------------- | ---- | ---------- |
| company_id                       | year | female_pct |
| 2a0a0700a3cf1c40a45c92839694390f | 2019 | 0.5        |
| 2a0a0700a3cf1c40a45c92839694390f | 2020 | 0.5        |
| 8a507c27a1d64dd429c919e424031a51 | 2017 | 0.875      |
| 8a507c27a1d64dd429c919e424031a51 | 2018 | 0.875      |
| 8a507c27a1d64dd429c919e424031a51 | 2019 | 0.875      |
| 8a507c27a1d64dd429c919e424031a51 | 2020 | 0.6        |

妙盈数仓面试题