Group

    PRQL

    1. group [title, country] (
    2.   aggregate [
    4.     ct = count
    5.   ]
    6. )

    SQL

    PRQL

    2. take 1

    SQL

    PRQL

    1. from employees
    2. group role (
    3.   sort join_date  # taken from above

    SQL