Untitled
public text v1 · immutableselect 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;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;