Another example shows how you can group results ... set returned after the groups are evaluated with the HAVING statement. SELECT company, AVG(net_amount), FROM Sales WHERE last_name BETWEEN ...

You can call more than one table in the statement’s FROM clause to combine results from multiple tables. Here’s an example of how this works: SELECT table1.column1, table2.column2 FROM table1 ...