Aggregated Views

I was hoping to create a view that is an aggregate of a certain form for example in this form, you have fields model and Km/L

http://creator.zoho.com/ojdelosreyes/fuel-consumption-matrix/

I want to group the data based on model and average the Km/L PER model and put that in a view.

Right now im unable to do so in zoho creator, in SQL i can do this as

select model, ave(km_l)
from table
group by model