SQL statement | Description |
SELECT DISTINCTROW | Creates two equi-joins: one between the Order Details and Orders tables, and another between the Orders and Employees tables. This is necessary because the Employees table doesn't contain sales data, and the Order Details table doesn't contain employee data. The query produces a list of employees and their total sales. |