Northwind
Basic Index Expanded Index
| View Name: | Order Subtotals |
| Field | Type | Nulls? | | OrderID | int | No |
| Subtotal | money | Yes |
create view "Order Subtotals" AS
SELECT "Order Details".OrderID, Sum(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS Subtotal
FROM "Order Details"
GROUP BY "Order Details".OrderID