SELECT SUM(provis) AS Provision FROM (SELECT DISTINCT Namn, MAX(Intjänat) as provis FROM Tjänad_Per_Månad
WHERE Slutdatum BETWEEN '2014-12-01' AND '2014-12-23'
GROUP BY Namn) As a