#group-by clear

Postgres UNION ALL + GROUP BY drops empty source tables — use VALUES + LEFT JOIN