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 ?