German Shopping Receipts

Answer grocery questions from august-cirrus-399913.economics.german_shopping_receipts using bq.

Process

1. Translate the question into one Standard SQL query.
2. Run bq query --nouse_legacy_sql --format=pretty '<sql>'.
3. Summarise the answer, naming the filters, grouping, and date range it rests on.

Done when the query ran without error and the summary states every filter, grouping, and date bound that shaped the number.

Schema

Reference the table path directly in FROM — no backticks, no escaping.