R (prqlr)

    1. library(prqlr)
    2. from employees
    3. join salaries [emp_id]
    4. group [dept_id, gender] (
    5. ]
    6. )
    7. " |>