公用表表达式 WITH employees AS ( SELECT employee_id, first_name, last_name FROM employee WHERE department_id = 10 ) SELECT * FROM employees WHERE last_name LIKE '%Smith%'; EXPLAIN ANALYZE 窗口函数