dataview
table WITHOUT ID
FROM #projects
GROUP BY status
If that doesn’t help, maybe explaining from Dataview documentation will aid you -
the GROUP by function is simply written as
GROUP BY field or in your case GROUP BY status
it might be the only way you haven’t tried, I did the exact thing 