title: Select query to get total records count in SQL Server
body: <p>Hi I have a table with status column. How to get total number of records, total number of records with pass status and total number of records with fail status using SQL ?</p>