Is there any way to do this kind of query in PGSQL?
SELECT count0, count1 FROM (
SELECT COUNT(*) AS count0
FROM measurement
WHERE responseTime = 0
GROUP BY responseTime
), (
SELECT COUNT(*) AS count1
FROM measurement
WHERE responseTime = 1
GROUP BY responseTime
)
;