原型sql统计图-百分比

SELECT
date_format( alarm_time, '%Y-%m-%d ’ ) AS day,
count( * ) AS Count
FROM
alarm_intelligence_management
WHERE
alarm_time >= '2020-07-02 ’
AND alarm_time <= '2020-07-22 ’
GROUP BY
date_format( alarm_time, ‘%Y-%m-%d’ );

select
count(*) as 人口总数,
sum(case when sex=0 then 1 else 0 end) 男人数,
sum(case when sex=0 then 1 else 0 end)1.0/count()男所占比例,
sum(case when sex=1 then 1 else 0 end) 女人数,
sum(case when sex=1 then 1 else 0 end)1.0 /count()女所占比例
from cj_yonghu