how to create a group view ?

how to greate a view with group by a field ?
like the SQL :
select field1,sum(field2),avg(field3), ... from table group by field1 ?
grassvalley