查找SceneId中UsersSex='男'的用户总数。
说明一下UsersName是UsersInfo主键，还是ApplyInfo外键。SceneId是ApplyInfo外键
------解决方案--------------------
不知是不是这个意思....
- SQL code
select applyinfo.sceneid,count(distinct usersname) as usersfrom applyinfo ,usersinfowhere applyinfo.usersname = usersinfo.usersnameand usersinfo.userssex = '男'group by applyinfo.sceneid