Не получается объединить SELECT запросы в одну таблицу

SELECT res 
FROM(
    SELECT DATE_PART('day', CURRENT_TIMESTAMP::TIMESTAMP - u.registration_date::TIMESTAMP) AS "days_registered" FROM users AS u WHERE u.id = 1
    (
        SELECT COUNT(uta.user_id)
        FROM users_to_achievements AS uta
        WHERE uta.user_id = 1 -- узнать сколько прошло дней с момента регистрации юзера Id = 1
        AND NOT uta.is_deleted 
    ) AS "achievements_got",
    (
        SELECT COUNT(vr.user_id)
        FROM violation_requests AS vr
        WHERE vr.user_id = 1
        AND vr.type_id IN (
        SELECT in_t.id
        FROM incident_types AS in_t
        WHERE in_t.parent_id = 1)
        AND vr.status IN ('confirmed'::incident_status)
        AND NOT vr.is_deleted
    ) AS "Confirmed_pdd",
    (
        SELECT COUNT(vr.user_id)
        FROM violation_requests AS vr
        WHERE vr.user_id = 1
        AND vr.type_id IN (
        SELECT in_t.id
        FROM incident_types AS in_t
        WHERE in_t.parent_id = 1)
        AND vr.status IN ('rejected'::incident_status)
        AND NOT vr.is_deleted
    ) AS "Rejected_pdd",
    (
        SELECT COUNT(vr.user_id)
        FROM violation_requests AS vr
        WHERE vr.user_id = 1
        AND vr.type_id IN (
        SELECT in_t.id
        FROM incident_types AS in_t
        WHERE in_t.parent_id = 1)
        AND vr.status IN ('pending'::incident_status)
        AND NOT vr.is_deleted
    ) AS "Pending_pdd",
    (
        SELECT u.rating
        FROM users AS u
        WHERE u.id = 1
    ) AS "Rating"
);

SELECT DATE_PART('day', CURRENT_TIMESTAMP::TIMESTAMP - u.registration_date::TIMESTAMP) AS "days_registered", 
       (SELECT COUNT(uta.user_id)
          FROM users_to_achievements AS uta
          WHERE uta.user_id = 1 -- узнать сколько прошло дней с момента регистрации юзера Id = 1
                AND NOT uta.is_deleted) AS "achievements_got",
       (SELECT COUNT(vr.user_id)
          FROM violation_requests AS vr
          WHERE vr.user_id = 1
                AND vr.type_id IN (SELECT in_t.id
                                     FROM incident_types AS in_t
                                     WHERE in_t.parent_id = 1)
                AND vr.status IN ('confirmed'::incident_status)
                AND NOT vr.is_deleted) AS "Confirmed_pdd",
       (SELECT COUNT(vr.user_id)
          FROM violation_requests AS vr
          WHERE vr.user_id = 1
                AND vr.type_id IN (SELECT in_t.id
                                     FROM incident_types AS in_t
                                     WHERE in_t.parent_id = 1)
                AND vr.status IN ('rejected'::incident_status)
                    AND NOT vr.is_deleted) AS "Rejected_pdd",
       (SELECT COUNT(vr.user_id)
          FROM violation_requests AS vr
          WHERE vr.user_id = 1
                AND vr.type_id IN (SELECT in_t.id
                                     FROM incident_types AS in_t
                                     WHERE in_t.parent_id = 1)
                AND vr.status IN ('pending'::incident_status)
                AND NOT vr.is_deleted) AS "Pending_pdd",
       u.rating
  FROM users AS u WHERE u.id = 1