SELECT
count( * ) AS count,
sum( CASE WHEN MOD ( substr( remark, 17, 1 ), 2 ) = 0 THEN 1 ELSE 0 END ) AS women,
sum( CASE WHEN MOD ( substr( remark, 17, 1 ), 2 ) = 1 THEN 1 ELSE 0 END ) AS man
FROM
t_user
SELECT
count( * ) AS count,
sum( CASE WHEN MOD ( substr( remark, 17, 1 ), 2 ) = 0 THEN 1 ELSE 0 END ) AS women,
sum( CASE WHEN MOD ( substr( remark, 17, 1 ), 2 ) = 1 THEN 1 ELSE 0 END ) AS man
FROM
t_user