统计一段时间各个行业采购总数,总人数和审核通过数量

2019独角兽企业重金招聘Python工程师标准>>>

SELECT
    category,
    COUNT(DISTINCT uid) AS sumUser,
    COUNT(id) AS purchaseCount,
    COUNT(
        IF (reviewStatus = 1, TRUE, NULL)
    ) AS reviewPassCount
FROM
    purchase_common pc
WHERE
    createTime >=?
AND createTime <=?
AND LENGTH(category) >= 6
GROUP BY
    category

转载于:https://my.oschina.net/u/2253438/blog/676223