Here it is:

SELECT temp.mnemonic, ata, name, class, type, status, CNT(*) FROM temp ;
INTO TABLE assignee_temp ;
WHERE group = gcGroup AND dept = gcDept ;
AND BETWEEN(assign_date,gdStartDate,gdEndDate) ;
GROUP BY 1,2,3


>What is the SQL statement you have tried that does not work?
>
>Jeff