How can I translate the following Sql query for Mongo?:

select a,b,sum(c) csum from coll where active=1 group by a,b order by a

Is there any way to execute a group and sort query with Mongo?

mongodb
Edit
Report