🔗概要

• JSON世界のSQL

🔗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
'