The general query syntax is:

select fields from tables where criteria order by field

where the bold words are values you supply
fields is a comma separated list. Tables are 'joined' to each other with a field name common to both in parenthesis

When a field is not unique to a table it must be qualified with the table name wherever it appears, e.g. sets.division

criteria is a logical contruction that may contain things like and, or,=,<,>,<>