framework/resources/Functional/subqueries/subquery_in_select/agg_func_avg_in_subquery.sql

SET `planner.enable_nljoin_for_scalar_only` = false;
SELECT
  m.employee_id,
  (
    SELECT
      AVG(sb.position_id) as avg_position
    FROM
      cp.`employee.json` as sb
    WHERE
      sb.employee_id < m.employee_id
  ) as avg_position
FROM
  cp.`employee.json` as m
WHERE
  m.gender LIKE 'F' LIMIT 5;
RESET `planner.enable_nljoin_for_scalar_only`;