Northwind - Summary of Sales by Quarter

Northwind

View Name:

Summary of Sales by Quarter

Field	Type	Nulls?
ShippedDate	datetime	Yes
OrderID	int	No
Subtotal	money	Yes

create view "Summary of Sales by Quarter" AS
SELECT Orders.ShippedDate, Orders.OrderID, "Order Subtotals".Subtotal
FROM Orders INNER JOIN "Order Subtotals" ON Orders.OrderID = "Order Subtotals".OrderID
WHERE Orders.ShippedDate IS NOT NULL
--ORDER BY Orders.ShippedDate