image.png
    考验个人理解的时候到了
    SELECT *
    FROM invoices
    WHERE invoice_total > ANY (
    SELECT MAX(invoice_total)
    FROM invoices
    WHERE client_id = 3
    )

    image.png
    SELECT
    FROM clients
    WHERE client_id = ANY(
    SELECT client_id
    FROM invoices
    GROUP BY client_id
    HAVING COUNT(    ) > 2
    )