Is it possible to have an aggregate SQL report for the last week shows the below result:

Group	Total number of received tickets	Completed tickets (closed, Resolved, canceled, rejected)	open tickets (open, assigned, in progress)	on hold tickets	overdue tickets

DB is MSSQL