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 >= UNIX_TIMESTAMP('2016-03-27') * 1000
AND createTime <= UNIX_TIMESTAMP('2016-04-26') * 1000
AND LENGTH(category) >= 6
GROUP BY
category
转载于:https://my.oschina.net/u/2253438/blog/676247