概要 †
SQLとの対応 †
SELECT status, count(*)
FROM test
WHERE organizationId = 1
GROUP by status
ORDER BY counter DESC;
cat test.json | jq '
map(select(.organizationId == 1))
| group_by(.status)
| map({status: .[0].status, count: length})
| sort_by(.count)
| reverse
'
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
