| status | count(case when type='code' then 'x' end) | count(case when type='doc' then 'x' end) | count(case when type='new' then 'x' end) | count(case when type NOT IN ('code','doc','new') then 'x' end) | count(*) |
|---|---|---|---|---|---|
| new | 1 | 0 | 1 | 0 | 2 |
| tested | 3 | 0 | 0 | 0 | 3 |
| review | 3 | 0 | 3 | 2 | 8 |
| defer | 4 | 1 | 31 | 2 | 38 |
| active | 6 | 14 | 126 | 15 | 161 |
| closed | 133 | 15 | 36 | 28 | 212 |
| fixed | 202 | 18 | 144 | 20 | 384 |
| TOTAL | 352 | 48 | 341 | 67 | 808 |
Rows: 8