Dear All,
I need to prepare small demo and I am not exactly an SQL wizzard. Pls give me you best SQL shots of how to slice and dice Northwind sales figures.

Sales by year,month,week, sales person, customer, quantities values etc.

I am talking about Northwind database shipped with VFP9.

Any help is greatly appreciated.

TIA
Sergio