The fields you have selected in the graphical view will be displayed in the
Syntax View which allows you to set their displaying order and modify the output
fields of the query using
<distinct>, <func> and <Alias>.
<distinct>
Enable this option if you wish the repeated records are not included into
the query result.
<func>
Set the aggregate functions (SUM, MAN, MIX, AVG, COUNT) for each field.
<Alias>
Change the output query field name.