【简答题】![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/logo-new-ad743.png)
在employee表中有以下信息{ "____id" : 1, "姓名" : "张飞", "性别" : "male", "年龄" : 18, "工号" : 20170301, "工资" : 7300.33, "职位" : "teacher","部门号" : 401 }{ "____id" : 2, "姓名" : "曹操", "性别" : "male", "年龄" : 28, "工号" : 20121101, "职位" : "teacher", "工资" : 2100, "部门号" : 401 }{ "____id" : 3, "姓名" : "诸葛亮", "性别" : "female", "年龄" : 18, "工号" : 20110211, "职位" : "teacher", "工资" : 9000, "部门号" : 401 }{ "____id" : 4, "姓名" : "周瑜", "性别" : "male", "年龄" : 18, "工号" : 19000301, "职位" : "teacher", "工资" : 30000, "部门号" : 401 }{ "____id" : 5, "姓名" : "司马懿", "性别" : "male", "年龄" : 48, "工号" : 20101111, "职位" : "teacher", "工资" : 10000, "部门号" : 401 }{ "____id" : 6, "姓名" : "袁绍", "性别" : "female", "年龄" : 48, "工号" : 20150311, "职位" : "sale", "工资": 3000.13, "部门号" : 402 }{ "____id" : 7, "姓名" : "张全蛋", "性别" : "female", "年龄" : 38, "工号" : 20101101, "职位" : "sale", "工资" : 2000.35, "部门号" : 402 }{ "____id" : 8, "姓名" : "曹操", "性别" : "female", "年龄" : 18, "工号" : 20110312, "职位" : "sale", "工资": 1000.37, "部门号" : 402 }{ "____id" : 9, "姓名" : "孙权", "性别" : "female", "年龄" : 18, "工号" : 20160513, "职位" : "sale", "工资": 3000.29, "部门号" : 402 }{ "____id" : 10, "姓名" : "貂蝉", "性别" : "female", "年龄" : 28, "工号" : 20170127, "职位" : "sale", "工资": 4000.33, "部门号" : 402 }计算职位为sale的员工的平均年龄
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/content_logo-3-f9358.png)
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAA5ElEQVRYR2NkGGDAOMD2M+B0wKpVq9huv/jbxPD/fxwDA4MkhQ59zsDIuEhVgrkuLCzsF7JZOB3QOml5B8P//+UUWoyqnZGxszovsoI4B0xc9gyfzxmZmb2rcsK3IRvWMWm599///7fgcfTz6vwoKWId8B+f75kZGX0q8iK3kugAhur8KJRQxx0FE5fhdQC5UTPqgNEQGA2B0RAYDYHREBgNgaETAuTW96TqG7yt4tbRFhGRIQBqHTP9+8dIoDUMTxqk5AK8zXKYiaDWMYhNpANIaJYPdMdkwLtmpOZnctUPeDkAAP6tmiH1ggTLAAAAAElFTkSuQmCC)
手机使用
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/share-ico-3febd.png)
分享
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/link-f6c98.png)
复制链接
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/weibo-3e538.png)
新浪微博
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/qq-1c308.png)
分享QQ
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/wechat-a78ae.png)
微信扫一扫
微信内点击右上角“…”即可分享
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/report-ico-11843.png)
反馈
![收藏 - 刷刷题](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/coll-ico-cfcc9.png)
收藏
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/jubao-9c477.png)
举报
![刷刷题](https://cdn-fe.shuashuati.com/sst-weixin-xcx/assets/shua/sst_w.png)
参考答案:
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/logo-new-ad743.png)
参考解析:
![](https://cos-cdn.shuashuati.com/shuashuati-web/2024-0521-0905-00/logo-new-ad743.png)