How many vendors does Adventure Works still work with but are not preferable?
not preferable refers to PreferredVendorStatus = 0; still work refers to ActiveFlag = 1;
SELECT COUNT(BusinessEntityID) FROM Vendor WHERE PreferredVendorStatus = 0 AND ActiveFlag = 1