);

In MS-SQL Not Equal does not work in SQL Query Then..

SELECT
    COUNT(ID) from [table]
WHERE
    COALESCE(status1, '') <> 'YES'
    AND COALESCE(status2, '') <> 'YES'
    AND COALESCE(status3, '') <> 'YES'