SELECT COUNT(*) 
FROM <Table_Name>
WHERE SITETYPE = 'condition'