COUNT Example:

SELECT COUNT(c.contract_id) AS CountContracts
   FROM contracts c
WHERE c.amount > 400 ;

See also: T-SQL Functions -> Avg -> Max -> Min -> Sum