如何为3列编写不同的查询

Question

我想通过(client、prop1、prop2)对每个唯一的行集进行状态求和。smth类: DISTINCT(client，prop1，prop2)

这是我的桌子

client  |  prop1  | prop2  | status
----------------------------------
name1   |  pr100  | pr310  | OK
name1   |  pr100  | pr310  | error
name1   |  pr100  | pr310  | OK
name1   |  pr100  | pr310  | OK
name2   |  pr255  | pr320  | OK
name2   |  pr255  | pr320  | OK
name2   |  pr255  | pr320  | error
name2   |  pr400  | pr320  | error
name3   |  pr400  | pr500  | OK
name3   |  pr400  | pr500  | OK

我试着得到这个：

client  |  prop1  | prop2  | OK  | error
----------------------------------
name1   |  pr100  | pr310  | 3   |  1
name2   |  pr255  | pr320  | 2   |  1
name2   |  pr400  | pr320  | 0   |  1
name3   |  pr400  | pr500  | 2   |  0

请帮帮忙

Answer 1

这是一个聚合，而不是一个select distinct

select client, prop1, prop2,
       sum(status = 'OK') as ok, sum(status = 'error') as error
from t
group by client, prop1, prop2;