教程
博客
开源案例
提问讨论
藏经阁
远方
英语
经济学
面经
缘来
登陆
首页
sql
数据结构
java
数仓建模
hive
flink
spark
数学
操作系统
hadoop
shell
发表新帖
妙盈数仓面试题
king
VIP3
1年前
0
500
## 面试题 | 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 |
回帖
一个叫大佬的人
VIP3
写的挺好的,加油!
提交回复