01Which of the following clauses is executed FIRST in the logical SQL processing pipeline?
02Why is 'WHERE YEAR(created_at) = 2024' considered a non-SARGable predicate?
03Why can you NOT use a SELECT alias (e.g., AS double_salary) in a WHERE clause?
04What is the performance risk of using a very large OFFSET (e.g., OFFSET 1,000,000) for pagination?
05Which of the following is a 'SARGable' predicate that allows the database engine to perform an O(log N) index seek?