Grouping or Summarizing Records

First, I accidentally came across ZOHO the other day. I must say the Creator is VERY impressive. I'm a programmer by trade but have no time use/learn .net or whatever to develop "quickie" type apps that I would use mostly for me. Zoho Creator seems to fit the bill for what I want. Congratulations.

I have developed a little small time tracker type application (for me only) that allows me to enter data, hours worked and a category ( and a few other things).

It works great. The only question I have that I can not seem to find through the help system is can I display a view that summarizes the hours per Category and or hours per day. In other words the equivalent of this sql:

select category, sum(hours) from mytable group by category

Is this even possible in ZOHO?

Thanks