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

SELECT
  m.employee_id,
  (
    SELECT
      COUNT(sub.position_id) as count_position_id
    FROM
      dfs.drilltestdir.`employee_json_for_subq` as sub
    GROUP BY sub.position_id
    HAVING COUNT(sub.position_id) > 5
    LIMIT 1
  ) as count_position_id
FROM
  cp.`employee.json` as m
WHERE
  m.gender LIKE 'F'
LIMIT 5;