结合SQL查询结果

SELECT e.name, d.name
FROM employees e
JOIN departments d ON e.department_id = d.id
WHERE d.name IN (SELECT name FROM departments WHERE location = 'New York');

SELECT e.name, d.name
FROM employees e
JOIN departments d ON e.department_id = d.id
WHERE d.location = 'New York';

SELECT name, COUNT(*) OVER (PARTITION BY department_id)
FROM employees;

WITH department_counts AS (
  SELECT department_id, COUNT(*) AS count
  FROM employees
  GROUP BY department_id
)
SELECT e.name, d.name, dc.count
FROM employees e
JOIN departments d ON e.department_id = d.id
JOIN department_counts dc ON e.department_id = dc.department_id;