程序员在开发需求的时候避免不了会有一些统计需求,按照不同维度统计总数。只需要一条sql搞定
SELECT
year_months,
office,
SUM( CASE WHEN biz_type='预算' THEN 1 ELSE 0 END ) budgetHcTotal,
SUM( CASE WHEN job_type = '白领' AND biz_type='预算' THEN 1 ELSE 0 END ) budgetWhiteHcTotal,
SUM( CASE WHEN job_type = '蓝领' AND biz_type='预算' THEN 1 ELSE 0 END ) budgetBlueHcTotal,
SUM( CASE WHEN job_type = '店端' AND biz_type='预算' THEN 1 ELSE 0 END ) budgetStoreHcTotal,
SUM( CASE WHEN biz_type='预测' THEN 1 ELSE 0 END ) forecastHcTotal,
SUM( CASE WHEN job_type = '白领' AND biz_type='预测' THEN 1 ELSE 0 END ) forecastWhiteHcTotal,
SUM( CASE WHEN job_type = '蓝领' AND biz_type='预测' THEN 1 ELSE 0 END ) forecastBlueHcTotal,
SUM( CASE WHEN job_type = '店端' AND biz_type='预测' THEN 1 ELSE 0 END ) forecastStoreHcTotal,
SUM( CASE WHEN biz_type=