sequelize: How to count a select subquery

47 Views Asked by At

I dont know how to create a non-raw query using sequelize like this:

SELECT
    COUNT(res.id)
FROM
    (
    SELECT
        clients.id,
        COUNT(client_addresses.id) AS total_client_addresses
    FROM
        clients
    LEFT OUTER JOIN client_addresses ON clients.id = client_addresses.client_id
    GROUP BY
        clients.id
    HAVING
        total_client_addresses > 0
) as res

Any suggestions for my query ?

0

There are 0 best solutions below