demo, PostgreSQL - rextester

Language: Layout:

--PostgreSQL 9.6
--'\\' is a delimiter

WITH server AS (
    SELECT 1 AS id UNION ALL
    SELECT 2 UNION ALL
    SELECT 3 UNION ALL
    SELECT 4
),
subscription AS (
    SELECT 1 AS id, 1 AS server_id UNION ALL
    SELECT 2, 2 UNION ALL
    SELECT 3, 2 UNION ALL
    SELECT 4, 3 UNION ALL
    SELECT 5, 3
),
error AS (
    SELECT 1 AS id, 1 AS server_id UNION ALL
    SELECT 3, 4
),
payment AS (
    SELECT 1 AS id, 1 AS server_id, 200 AS amount UNION ALL
    SELECT 2, 2, 200 UNION ALL
    SELECT 3, 2, 100
)

SELECT
    s.id AS server_id,
    COALESCE(e.countErrors, 0) AS countErrors,
    COALESCE(p.sumPayments, 0) AS sumPayments
FROM server s
INNER JOIN
(
    SELECT DISTINCT server_id
    FROM subscription
) su
    ON s.id = su.server_id
LEFT JOIN
(
    SELECT server_id, COUNT(*) AS countErrors
    FROM error
    GROUP BY server_id
) e
    ON s.id = e.server_id
LEFT JOIN
(
    SELECT server_id, SUM(amount) AS sumPayments
    FROM payment
    GROUP BY server_id
) p
    ON s.id = p.server_id
WHERE
    p.sumPayments > 0 OR
    e.countErrors > 0
ORDER BY
    s.id;


absolute service time: 0,46 sec