tools/bqpipeline/example/q1.sql

select
  category,
  sum(sales_amt) sales_amt,
  sum(sales_unit_qty) sales_unit_qty
from `{{ project }}.{{ dataset }}.example_table_1`
where date >= '2019-02-01' and date < '2019-02-14'
group by category