按日期分组，确认，待定 [英] group by date, confirm, pending

问题描述

我正在尝试为每天的用户构建图表，其中包含每天的已确认用户总数和待处理用户总数，我需要如下数据:

im trying to build chart for users for each day with total confirmed user and total pending users for that each day and i need data like following:

date         |   confirmed    |  pending
2010-01-05   |   5            |  2      
2010-01-06   |   10           |  3

表的结构如下:

user_id
username
confirm     enum(0,1)
date        date 

推荐答案

SELECT Date, SUM(CASE Confirm WHEN 1 THEN 1 ELSE 0 END) Confirmed,
  SUM(CASE Confirm WHEN 0 THEN 1 ELSE 0 END) Pending,
 FROM Table
GROUP BY Date

这篇关于按日期分组，确认，待定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！