need a sql query to count total of a row with where condition for weekly report. like a i have table with a row like status. there is different status ( warrant/not warranty/ done). now i want to show total count from status row for warranty for a week. can anyone help me?