使用子查询....像这样:

use a sub query.... like this:

select Submitter_CH_ID, Submitter_Last_Name, count(ID) AS [Total Submissions]
from (
    select ID, Submitter_CH_ID, Submitter_Last_Name
    from  dbo.Recognitions
    where date >= @start_date and date <= @end_date
) T
GROUP BY Submitter_CH_ID, Submitter_Last_Name

是子查询！