Order SQL query logical processing steps

Take the following SQL-92 style query:

SELECT foo, COUNT(foo)
FROM pokes
WHERE foo > 10
GROUP BY foo
HAVING COUNT(foo) > 1
ORDER BY foo;

Which choice below shows the logical order in which the SQL clauses are processed conceptually, according to the SQL-92 standard?

Choices:

• A. FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY
• B. FROM → GROUP BY → WHERE → HAVING → SELECT → ORDER BY
• C. FROM → WHERE → GROUP BY → HAVING → ORDER BY → SELECT
• D. FROM → WHERE → ORDER BY → GROUP BY → HAVING → SELECT

Overview: The item tests a candidate's grasp of SQL-92 logical query processing order and relational query semantics, checking the ability to reason about clause evaluation, aggregation, and filtering.