---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# mysql:skip\n# clickhouse:skip\n# glaredb:skip (the string_agg function is not supported)\nfrom tracks\nfilter genre_id == 100\nderive empty_name = name == ''\naggregate {sum track_id, concat_array name, all empty_name, any empty_name}\n"
input_file: prqlc/prqlc/tests/integration/queries/aggregation.prql
snapshot_kind: text
---
from tracks
filter genre_id == 100
derive empty_name = name == ""
aggregate {
  sum track_id,
  concat_array name,
  all empty_name,
  any empty_name,
}