By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 6
| project_id | task_id | foo | bar | job_id | count |
|---|---|---|---|---|---|
| 1 | 12 | x | y | 13 | 3 |
| 1 | 12 | x | z | 14 | 3 |
| 1 | 12 | a | b | 15 | 3 |
| 1 | 1210 | x | y | 1211 | 2 |
| 1 | 1210 | z | v | 1212 | 2 |
| 1 | 1220 | aa | bb | 1221 | 1 |
SELECT 6