SELECT

    B.vchValue,

    COUNT(*) AS Antal

FROM

    Avtal_Elavtal E

    INNER JOIN Avtal_AvtalsStatus B

    ON E.godkand = B.statusId

WHERE 

    E.electronicdeal = 1

GROUP BY

    B.vchValue

ORDER BY

    Antal