[SQL] Nombre de sites résorbés

SELECT
    COUNT(*)
FROM
    shantytowns s
WHERE
    s.closed_at IS NOT NULL
    AND EXTRACT(MONTH FROM s.closed_at) = 10.0
    AND EXTRACT(YEAR FROM s.closed_at) = 2020.0
    AND closed_with_solutions = 'yes';