================================================================================
Group by
================================================================================

SELECT other_id, COUNT(name)
FROM my_table
GROUP BY other_id
HAVING other_id > 10;

--------------------------------------------------------------------------------

(program
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          value: (field
            name: (identifier)))
        (term
          value: (invocation
            (object_reference
              name: (identifier))
            parameter: (term
              value: (field
                name: (identifier)))))))
    (from
      (keyword_from)
      (relation
        (object_reference
          name: (identifier)))
      (group_by
        (keyword_group)
        (keyword_by)
        (field
          name: (identifier)))
	(having
        (keyword_having)
        (binary_expression
          left: (field
            name: (identifier))
          right: (literal))))))

================================================================================
Group by numbered alias
================================================================================

SELECT other_id, COUNT(name)
FROM my_table
GROUP BY 1
HAVING other_id > 10;
--------------------------------------------------------------------------------

(program
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          value: (field
            name: (identifier)))
        (term
          value: (invocation
            (object_reference
              name: (identifier))
            parameter: (term
              value: (field
                name: (identifier)))))))
    (from
      (keyword_from)
      (relation
        (object_reference
          name: (identifier)))
      (group_by
        (keyword_group)
        (keyword_by)
        (literal))
	(having
        (keyword_having)
        (binary_expression
          left: (field
            name: (identifier))
          right: (literal))))))

================================================================================
Group by with mixed list
================================================================================

SELECT other_id, other_col, COUNT(name)
FROM my_table
GROUP BY 1, other_col
HAVING other_id > 10;
--------------------------------------------------------------------------------

(program
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          value: (field
            name: (identifier)))
        (term
          value: (field
            name: (identifier)))
        (term
          value: (invocation
            (object_reference
              name: (identifier))
            parameter: (term
              value: (field
                name: (identifier)))))))
    (from
      (keyword_from)
      (relation
        (object_reference
          name: (identifier)))
      (group_by
        (keyword_group)
        (keyword_by)
        (literal)
        (field
          name: (identifier)))
	  (having
        (keyword_having)
        (binary_expression
          left: (field
            name: (identifier))
          right: (literal))))))

================================================================================
Having with count function
================================================================================

SELECT other_id, COUNT(name)
FROM my_table
GROUP BY other_id
HAVING COUNT(*) = 2;

--------------------------------------------------------------------------------

(program
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          value: (field
            name: (identifier)))
        (term
          value: (invocation
            (object_reference
              name: (identifier))
            parameter: (term
              value: (field
                name: (identifier)))))))
    (from
      (keyword_from)
      (relation
        (object_reference
          name: (identifier)))
      (group_by
        (keyword_group)
        (keyword_by)
        (field
          name: (identifier)))
	  (having
        (keyword_having)
        (binary_expression
          left: (invocation
            (object_reference
              name: (identifier))
            parameter: (term
              value: (all_fields)))
          right: (literal))))))

================================================================================
Having without group by
================================================================================

SELECT COUNT(*) as cnt
FROM db.table
HAVING cnt = 2
;

--------------------------------------------------------------------------------

    (program
      (statement
        (select
          (keyword_select)
          (select_expression
            (term
              (invocation
                (object_reference
                  (identifier))
                (term
                  (all_fields)))
              (keyword_as)
              (identifier))))
        (from
          (keyword_from)
          (relation
            (object_reference
              (identifier)
              (identifier)))
          (having
            (keyword_having)
            (binary_expression
              (field
                (identifier))
              (literal))))))

================================================================================
Group by all
================================================================================

SELECT other_id, COUNT(name)
FROM my_table
GROUP BY ALL
HAVING COUNT(name) > 1
ORDER BY other_id;

--------------------------------------------------------------------------------

(program
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          (field
            (identifier)))
        (term
          (invocation
            (object_reference
              (identifier))
            (term
              (field
                (identifier)))))))
    (from
      (keyword_from)
      (relation
        (object_reference
          (identifier)))
      (group_by
        (keyword_group)
        (keyword_by)
        (keyword_all))
      (having
        (keyword_having)
        (binary_expression
          (invocation
            (object_reference
              (identifier))
            (term
              (field
                (identifier))))
          (literal)))
      (order_by
        (keyword_order)
        (keyword_by)
        (order_target
          (field
            (identifier)))))))

================================================================================
Group by all with grouping expressions
================================================================================

SELECT a, b, COUNT(*)
FROM my_table
GROUP BY ALL a, b;

--------------------------------------------------------------------------------

(program
  (statement
    (select
      (keyword_select)
      (select_expression
        (term
          (field
            (identifier)))
        (term
          (field
            (identifier)))
        (term
          (invocation
            (object_reference
              (identifier))
            (term
              (all_fields))))))
    (from
      (keyword_from)
      (relation
        (object_reference
          (identifier)))
      (group_by
        (keyword_group)
        (keyword_by)
        (unary_expression
          (keyword_all)
          (field
            (identifier)))
        (field
          (identifier))))))
