Database problems

Question 1

The usage of GROUP BY

Answer 1

1. for selection in one table, the select clause should only contains the field used in GROUP BY clause and aggregation functions: sum, avg, min, max….
2. Exception: if there are two or more tables (join), other table’s field used in where clause (for join) can appear in the SELECT clause