How to summarize data in a table?

Question

PostgreSQL

Hello! There is data from the database, the data is located on all tables of the database.
I was told to make the following table:

=========== =============
| Accepted | Rejected |
=========== =============

I made one by one, please help me to make them merged.

Accepted

SELECT SUM(confirmed) AS "confirmed_ones"
FROM(
    SELECT COUNT(vr.status) AS confirmed
    FROM violation_requests AS vr
    WHERE vr.user_id = 1
    AND vr.status IN('confirmed'::incident_status)
    AND NOT vr.is_deleted

    UNION 

    SELECT COUNT(c.status)
    FROM complaints AS c
    WHERE c.user_id = 1
    AND c.status IN('confirmed'::incident_status)
    AND NOT c.is_deleted
) AS res;

Rejected

SELECT SUM(rejected) AS "rejected_ones"
FROM(
    SELECT COUNT(vr.status) AS rejected
    FROM violation_requests AS vr
    WHERE vr.user_id = 1
    AND vr.status IN ('rejected'::incident_status)
    AND NOT vr.is_deleted

    UNION

    SELECT COUNT(c.status)
    FROM complaints AS c
    WHERE c.user_id = 1
    AND c.status IN ('rejected'::incident_status)
    AND NOT c.is_deleted
) AS res;

No matter what I tried to do, it didn't work. Help me please.

Answer 1

SELECT user_id, SUM(confirmed) AS "confirmed_ones"
FROM(
    SELECT vr.user_id user_id, COUNT(vr.status) AS confirmed
    FROM violation_requests AS vr
    AND vr.status IN('confirmed'::incident_status)
    AND NOT vr.is_deleted
    GROUP BY  vr.user_id = 1

    UNION 

    SELECT c.user_id, COUNT(c.status)
    FROM complaints AS c
    AND c.status IN('confirmed'::incident_status)
    AND NOT c.is_deleted
    GROUP BY  c.user_id
) AS res
GROUP BY  user_id;