---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# clickhouse:skip (ClickHouse prefers aliases to column names https://github.com/PRQL/prql/issues/2827)\n# mssql:test\nlet genre_count = (\n    from genres\n    aggregate {a = count name}\n)\n\nfrom genre_count\nfilter a > 0\nselect a = -a\n"
input_file: prqlc/prqlc/tests/integration/queries/genre_counts.prql
snapshot_kind: text
---
let genre_count = (
  from genres
  aggregate {a = count name}
)

from genre_count
filter a > 0
select a = -a