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