как писать select с групировкой

[mit]

Руководство разработчика топик
"Select statement"
Syntax of select

SelectStatement = select Parameters
Parameters = [ [ FindOptions ] [ FieldList from ] ] TableVariable [IndexClause] [ Options ] [ Where Clause ] [ JoinClause ]
FindOptions = reverse | firstfast | firstonly | forupdate | nofetch
FieldList = Field { , Field } | *
Field = Aggregate ( FieldIdentifier ) | FieldIdentifier
Aggregate = sum | avg | minof | maxof | count
Options = (order by | group by ) FieldIdentifier [ Direction ] { , FieldIdentifier [ Direction ] }
IndexCaluse = index Idx | index hint idx
Direction = asc | desc
WhereClause = where Expression
JoinClause = [exists | notexists | outer ] join Parameters