56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
a.sexs AS sex,
IFNULL(b.percentage,0)AS percentage
FROM (
SELECT 'male' AS sexs
UNION ALL
SELECT 'female'
) a
LEFT JOIN
(
SELECT
P.SEX,
COUNT(1) /
(15315)AS percentage
FROM player_login_logout_log A
LEFT JOIN player_create_log P ON A.`role_id`=P.ROLE_ID
WHERE player_state='login'
-- AND IF(_system_type IS NULL ,0=0,a.system_type=_system_type) AND IF(_platform IS NULL,0=0,a.platform=_platform) AND IF(_zone_id IS NULL ,0=0,a.zone_id=_zone_id)
AND LEFT(A.time,10) BETWEEN '2018-04-01' AND '2018-04-30'
GROUP BY P.SEX
)b ON a.sexs=b.sex;