table newest_employees = (
  from employees
  sort tenure
  take 50
)

table average_salaries = (
  from salaries
  aggregate by:country [
    average_country_salary: average salary
  ]
)

from newest_employees
join average_salaries [country]
select [name, salary, average_country_salary]