LISTING 7: Query of Operational Database to Return Number of Items Ordered

use northwind

select
	'Q' + convert(char (2), datepart(q, o.orderdate)) as quarter,
	ca.categoryname,
	sum(od.quantity) as quantity
from
	orders as o
join
	[order details] as od
on
	o.orderid = od.orderid
join
	products as p
on
	od.productid = p.productid
join
	categories as ca
on
	p.categoryid = ca.categoryid
join
	customers as cu
on
	o.customerid = cu.customerid
where
	year(o.orderdate) = 1997
and
	cu.country = 'usa'
group by
	'Q' + convert(char (2), datepart(q, o.orderdate)),
	ca.categoryname
order by
	'Q' + convert(char(2), datepart(q, o.orderdate)),
	ca.categoryname