---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# mssql:test\nfrom tracks\nselect {album_id, genre_id}\ngroup tracks.* (take 1)\nsort tracks.*\n"
input_file: prqlc/prqlc/tests/integration/queries/distinct.prql
snapshot_kind: text
---
frames:
- - 1:25-52
  - columns:
    - !Single
      name:
      - tracks
      - album_id
      target_id: 126
      target_name: null
    - !Single
      name:
      - tracks
      - genre_id
      target_id: 127
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:69-75
  - columns:
    - !Single
      name:
      - tracks
      - album_id
      target_id: 131
      target_name: null
    - !Single
      name:
      - tracks
      - genre_id
      target_id: 132
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:77-90
  - columns:
    - !Single
      name:
      - tracks
      - album_id
      target_id: 131
      target_name: null
    - !Single
      name:
      - tracks
      - genre_id
      target_id: 132
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
nodes:
- id: 124
  kind: Ident
  span: 1:13-24
  ident: !Ident
  - default_db
  - tracks
  parent: 129
- id: 126
  kind: Ident
  span: 1:33-41
  ident: !Ident
  - this
  - tracks
  - album_id
  targets:
  - 124
  parent: 128
- id: 127
  kind: Ident
  span: 1:43-51
  ident: !Ident
  - this
  - tracks
  - genre_id
  targets:
  - 124
  parent: 128
- id: 128
  kind: Tuple
  span: 1:32-52
  children:
  - 126
  - 127
  parent: 129
- id: 129
  kind: 'TransformCall: Select'
  span: 1:25-52
  children:
  - 124
  - 128
  parent: 150
- id: 131
  kind: Ident
  ident: !Ident
  - this
  - tracks
  - album_id
  targets:
  - 126
  parent: 133
- id: 132
  kind: Ident
  ident: !Ident
  - this
  - tracks
  - genre_id
  targets:
  - 127
  parent: 133
- id: 133
  kind: Tuple
  span: 1:65-67
  children:
  - 131
  - 132
- id: 150
  kind: 'TransformCall: Take'
  span: 1:69-75
  children:
  - 129
  - 151
  parent: 158
- id: 151
  kind: Literal
  parent: 150
- id: 155
  kind: Ident
  ident: !Ident
  - this
  - tracks
  - album_id
  targets:
  - 131
  parent: 158
- id: 156
  kind: Ident
  ident: !Ident
  - this
  - tracks
  - genre_id
  targets:
  - 132
  parent: 158
- id: 158
  kind: 'TransformCall: Sort'
  span: 1:77-90
  children:
  - 150
  - 155
  - 156
ast:
  name: Project
  stmts:
  - VarDef:
      kind: Main
      name: main
      value:
        Pipeline:
          exprs:
          - FuncCall:
              name:
                Ident: from
                span: 1:13-17
              args:
              - Ident: tracks
                span: 1:18-24
            span: 1:13-24
          - FuncCall:
              name:
                Ident: select
                span: 1:25-31
              args:
              - Tuple:
                - Ident: album_id
                  span: 1:33-41
                - Ident: genre_id
                  span: 1:43-51
                span: 1:32-52
            span: 1:25-52
          - FuncCall:
              name:
                Ident: group
                span: 1:53-58
              args:
              - Indirection:
                  base:
                    Ident: tracks
                    span: 1:59-65
                  field: Star
                span: 1:65-67
              - FuncCall:
                  name:
                    Ident: take
                    span: 1:69-73
                  args:
                  - Literal:
                      Integer: 1
                    span: 1:74-75
                span: 1:69-75
            span: 1:53-76
          - FuncCall:
              name:
                Ident: sort
                span: 1:77-81
              args:
              - Indirection:
                  base:
                    Ident: tracks
                    span: 1:82-88
                  field: Star
                span: 1:88-90
            span: 1:77-90
        span: 1:13-90
    span: 1:0-90