R (prqlr)

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