SELECT

    B.vchValue,

    COUNT(*) AS Antal

FROM 

    Avtal_Elavtal E

    INNER JOIN Avtal_AvtalsStatus_Blivande B

    ON E.iFullmaktsStatus = B.statusId

WHERE 

    E.electronicdeal = 0

GROUP BY

    B.vchValue

ORDER BY

    Antal