SQL SUM with condition / Invalid column name 'SUM'

Question

I'm trying to make a sum of the variable value/valeur with some conditions but I obtain this error: Invalid column name 'SUM'.

SELECT SUM[value/valeur] 
FROM [dbo].[tmp_norm_can]
WHERE [state/etat] = '1000' 
  AND [geo/geo] = '1' 
  AND [country/pays] != '999'

I attached an image of the database

Thank you very much!

enter image description here

Answer 1

Thank you!

The code that worked was: SELECT SUM(CAST([value/valeur] AS NUMERIC)) AS "TOTAL", [year/annee] FROM [dbo].[tmp_norm_can] WHERE [state/etat] = '1000' AND [geo/geo] = '1' AND [country/pays] != '999'