---
source: prql/tests/integration/examples.rs
expression: sql
input_file: prql/tests/integration/examples/employees-1.prql
---
WITH table_0 AS (
  SELECT
    emp_no,
    gender,
    AVG(salary) AS emp_salary
  FROM
    employees
    JOIN salaries USING(emp_no)
  GROUP BY
    emp_no,
    gender
),
table_1 AS (
  SELECT
    de.dept_no,
    gender,
    AVG(emp_salary) AS salary_avg,
    STDDEV(emp_salary) AS salary_sd
  FROM
    table_0
    LEFT JOIN dept_emp AS de USING(emp_no)
  GROUP BY
    de.dept_no,
    gender
)
SELECT
  dept_name,
  gender,
  salary_avg,
  salary_sd
FROM
  table_1
  JOIN departments USING(dept_no)