I'm trying to setup a osqueryd query to report back the process-to-program utilization... im trying to

group by

name but getting this error any suggestions?

select pid, name, uid, resident_size from processes order by resident_size desc group by name;

Error: near "group": syntax error