Back to Details

german-shopping-receipts

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

German Shopping Receipts

德国购物收据

Answer grocery questions from 
august-cirrus-399913.economics.german_shopping_receipts
using 
bq
.
使用
bq
回答来自
august-cirrus-399913.economics.german_shopping_receipts
表的食品杂货相关问题。

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.
  1. 将问题转换为一条标准SQL查询语句。
  2. 执行
    bq query --nouse_legacy_sql --format=pretty '<sql>'
    命令。
  3. 总结答案，说明所使用的筛选条件、分组方式以及依赖的日期范围。
当查询无错误执行，且总结中明确说明所有影响结果数值的筛选条件、分组方式和日期限制时，任务完成。

Schema

表结构

Reference the table path directly in 
FROM
— no backticks, no escaping.
ColumnTypeNotes
supermarketSTRING
dateDATEPurchase date — the one to filter and group on
item_name_germanSTRING
item_name_englishSTRING
priceFLOATPer-item price; the column for item-level analysis
total_priceFLOATReceipt total, repeated on every line item — summing it multiplies by line count
inserted_atTIMESTAMPLoad time, not purchase time
A receipt is the set of rows sharing a 
supermarket
and 
date
. Count receipts with 
COUNT(DISTINCT ...)
over that pair, and take a receipt total with 
MAX(total_price)
per group.
在
FROM
子句中直接引用表路径——无需反引号，无需转义。
ColumnTypeNotes
supermarketSTRING
dateDATE购买日期——用于筛选和分组的字段
item_name_germanSTRING
item_name_englishSTRING
priceFLOAT单件商品价格；用于商品级别分析的字段
total_priceFLOAT收据总金额，在每个行项目中重复出现——对其求和会乘以行项目数量
inserted_atTIMESTAMP加载时间，非购买时间
一张收据对应一组共享
supermarket
和
date
的行数据。使用
COUNT(DISTINCT ...)
对这一对字段计数来统计收据数量，并使用每组的
MAX(total_price)
获取收据总金额。