1条回答 默认 最新
dragon_data 2019-06-14 14:15关注SELECT a.departmentName, a.c, b.d FROM
(select departmentName,COUNT(*) c from employees where DepartmentName!= 'to' group by departmentName) a LEFT JOIN
(select count(*) d,departmentName from employees where maritalStatus='S' and gender='M' group by departmentName) b
ON a.departmentName = b.departmentName
having (b.d/a.c)>0.3本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
