By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH dates AS (
SELECT '2019-08-14' AS click_date UNION ALL
SELECT '2019-08-04' UNION ALL
SELECT '2019-07-24'
),
Clicks AS (
SELECT '2019-08-04' AS date, 3422 AS clicker, 2 AS click_count UNION ALL
SELECT '2019-07-24', 3539, 7
)
SELECT
d.click_date,
c1.clicker,
COALESCE(c2.click_count, 0) AS click_count
FROM dates d
CROSS JOIN Clicks c1
LEFT JOIN Clicks c2
ON d.click_date = c2.date AND c1.clicker = c2.clicker
ORDER BY
c1.clicker,
d.click_date;
| click_date | clicker | click_count |
|---|---|---|
| 2019-07-24 | 3422 | 0 |
| 2019-08-04 | 3422 | 2 |
| 2019-08-14 | 3422 | 0 |
| 2019-07-24 | 3539 | 7 |
| 2019-08-04 | 3539 | 0 |
| 2019-08-14 | 3539 | 0 |