Order SQL query logical processing steps

Q: Order SQL query logical processing steps

This is a Software Engineering Fundamentals interview question from Bitkernel for Software Engineer roles. View the full question and solution on PracHub.

Q: How do I approach Software Engineering Fundamentals interview questions?

Software Engineering Fundamentals questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master software engineering fundamentals interviews.

Question

Consider a SQL query written in SQL-92 style:

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

Which of the following represents the logical order in which the SQL clauses are processed (conceptual evaluation order), according to the SQL-92 standard?

Options:

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

Order SQL query logical processing steps

Solution

Comments (0)