SELECT (SELECT COUNT(*) FROM users)                            AS total_users,
       (SELECT COUNT(*)
        FROM users u
                 INNER JOIN user_data ud ON ud.user_id = u.id) AS total_registered,
       (SELECT COUNT(*) FROM events)                           AS total_events,
       (SELECT COUNT(*) FROM send_message)                     AS total_send_messages;

SELECT ue.id,
       ue."rsvpChoice"                                                                   AS rsvp_choice,
       ue."isRspv"                                                                       AS is_rspv,
       ue."isAttendance"                                                                 AS is_attendance,

       jsonb_build_object('id', u.id, 'tgId', u.tg_id, 'uniqueCode', u.user_unique_code) as user,
       jsonb_build_object('id', ud.id, 'name', ud.name, 'surname', ud.surname)           AS user_data

FROM user_events ue
         LEFT JOIN users u ON ue.user_id = u.id
         LEFT JOIN user_data ud ON ud.user_id = u.id
WHERE ue.event_id = 87;

SELECT e.id,
       e.name,
       e.date,
       e.location,
       e.description,
       e.category,
       SUM(CASE WHEN ue."isRspv" = TRUE THEN 1 ELSE 0 END)       AS total_rsvp,
       SUM(CASE WHEN ue."isAttendance" = TRUE THEN 1 ELSE 0 END) AS total_attendance
FROM events e
         LEFT JOIN user_events ue ON ue.event_id = e.id
WHERE e.id = 87
GROUP BY e.id,
         e.name,
         e.date,
         e.location,
         e.description,
         e.category
ORDER BY e.date DESC
LIMIT 20 OFFSET 0;