WITH vacance_commerciale AS (
  SELECT
    insee_com,
    COALESCE(SUM(nb_emplacements_vacants), 0) AS emplacements_vacants,
    COALESCE(SUM(nb_emplacements_commerciaux), 0) AS emplacements_commerciaux
  FROM vacance_commerciale
  GROUP BY
    insee_com
)
SELECT
  commune.nccenr,
  commune.tncc,
  CAST(CAST(emplacements_vacants AS REAL) / CAST(emplacements_commerciaux AS REAL) * 100 AS DECIMAL(4, 1)) AS taux
FROM vacance_commerciale
JOIN commune
  ON commune.insee_com = vacance_commerciale.insee_com
WHERE
  emplacements_commerciaux > 0
ORDER BY
  nccenr