I suggest watching the screencast. It has examples of some pretty complex queries including aggregating and group by.