tools/bqpipeline/example/q4.sql

select
  department_number,
  division,
  sum(sales_amt) sales_amt,
  sum(sales_unit_qty) sales_unit_qty
from example_table_2
where date >= '2019-02-01' and date < '2019-02-14'
group by department_number, division