Как правильно написать json запрос на PostgreSQL?

SELECT to_json(ratioIIAndOtherPrograms)
FROM (
    SELECT SUM(active_time) AS share_activeTime, 
        SUM(CASE WHEN is_ai = TRUE THEN active_time END) AS active_timeAI
    FROM public.departments_productivity
    WHERE DATE >= '2025-06-01' AND DATE < '2025-06-30'
) AS ratioIIAndOtherPrograms

SELECT to_json(mostPopular)
FROM (
SELECT t.type_app, t.name_app, active_time
FROM (
SELECT type_app, name_app, SUM(active_time) AS active_time
FROM public.departments_productivity
WHERE DATE > '2025-05-01' AND DATE < '2025-06-30'
GROUP BY type_app, name_app 
) t
WHERE t.type_app = 'WEBSITE'
ORDER BY active_time DESC LIMIT 1
) AS mostPopular

WITH ratioIIAndOtherPrograms AS
 (SELECT SUM(active_time) AS share_activeTime,
         SUM(CASE WHEN is_ai = TRUE THEN active_time END) AS active_timeAI
    FROM public.departments_productivity
   WHERE DATE >= '2025-06-01' AND DATE < '2025-06-30'),
mostPopular AS
 (SELECT t.type_app, t.name_app, active_time
    FROM (SELECT type_app, name_app, SUM(active_time) AS active_time
            FROM public.departments_productivity
           WHERE DATE > '2025-05-01' AND DATE < '2025-06-30'
           GROUP BY type_app, name_app) t
   WHERE t.type_app = 'WEBSITE'
   ORDER BY active_time DESC LIMIT 1)
SELECT JSON_BUILD_OBJECT('ratioIIAndOtherPrograms', TO_JSON(ratioIIAndOtherPrograms), 'mostPopular', TO_JSON(mostPopular));