Trying to generate data for a chart report. looking to get the count of records for each new_submissionstatus.all I get with this query is 'no Colum name' where I'm looking for 'Unsubmitted', Accepted etc
SELECT COUNT(CASE new_submissionstatus
WHEN 1 THEN 'UNSUBMITTED'
WHEN 2 THEN 'ACCEPTED'
WHEN 3 THEN 'PROCESSING'
WHEN 4 THEN 'SUBMITTED'
WHEN 5 THEN 'REJECTED'
WHEN 6 THEN 'EXTRACTED'
WHEN 7 THEN 'APPROVAL'
Where DATEDIFF(d, new_submitteddate, GETDATE()) = 0
GROUP BY [new_submissionstatus]