Daily, Weekly, Total Row Count in Multiple Columns

counts.sql

SELECT
   SUM(CASE WHEN KY='daily' THEN COUNT ELSE 0 END) "daily",
   SUM(CASE WHEN KY='weekly' THEN count ELSE 0 END) "weekly",
   SUM(CASE WHEN KY='total' THEN count ELSE 0 END) "total"
FROM 
(
SELECT 'daily' AS KY ,COUNT(*) FROM PUBLIC."Articles" WHERE "Articles"."createdAt" >= NOW() - '1 day'::INTERVAL
UNION
SELECT 'weekly' AS KY ,COUNT(*) FROM PUBLIC."Articles" WHERE "Articles"."createdAt" >= NOW() - '1 week'::INTERVAL
UNION
SELECT 'total' AS KY ,COUNT(*) FROM PUBLIC."Articles"
) AS TB

Note: It's for postgresql