All pastes #910713 Raw Edit

Untitled

public text v1 · immutable
·published 2008-02-20 03:42 UTC
rendered paste body
select count (distinct customer_code) stores, year(invoice_date) as y, month(invoice_date) as m from sh_transaction
  group by year(invoice_date), month(invoice_date)
  order by y, m;