显示基于几列的计数 - 报表查询

Question

我有一个报告，根据用户、资费计划操作类型和交易状态显示交易计数。最好的方法是什么。多重分组是否可能且可行？

示例数据和输出：

Date         Plan            Total  USer   Type of operation    status product 
2/8/2017    Entel Prepago Smart 5   01234567    Venta          Success   sim
2/8/2017    Super Plan          3   01234568    Venta          Success  pack
2/8/2017    Entel Prepago Smart 1   01234567    Venta          Cancel   sim
2/8/2017    Super Plan          1   01234568    Venta          Cancel   sim
2/8/2017    Entel Prepago       2   01234567    Reposicion     Cancel   sim
2/9/2017    Entel Prepago       10  01234570    Portabilidad  Success   pack
2/9/2017    Entel Prepago Smart 1   01234567    Venta         Pending   pack
2/9/2017    Super Plan          1   01234568    Portabilidad  Success   sim

Answer 1

是的，您可以按多个分组。

您可以尝试此查询： SELECT COUNT(transaction), user, tariff_plan, status FROM your_table GROUP BY user, tariff_plan, status

Answer 2

试试这个：

select
    user, plan, type_of_operation, status,
    count(*) cnt
from your_table
group by
    user, plan, type_of_operation, status;