Specify the steps needed for evaluating an SQL statement of the form

Question

SELECT thing1
FROM thing2
WHERE thing3
GROUP BY thing4
HAVING thing5
ORDER BY thing6

Answer 1

1. Take all tables listed in thing2, compute their cross product
2. Select rows of the cross product that satisfy the condition in thing3
3. Group the selected rows by attribute thing4
4. Select the groups that satisfy the condition in thing5
5. Project out for the selected groups attributes in thing1
6. Sort the result by attributes in thing6