830rows
2 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
OrderID | TEXT | yes | — | — |
Subtotal | TEXT | yes | — | — |
View definition
CREATE VIEW [Order Subtotals] AS
SELECT [Order Details].OrderID,
Sum(([Order Details].UnitPrice*Quantity*(1-Discount)/100)*100) AS Subtotal
FROM [Order Details]
GROUP BY [Order Details].OrderIDData preview
Sample records
| OrderID | Subtotal |
|---|---|
| 10248 | 440 |
| 10249 | 1863.4 |
| 10250 | 1552.6 |
| 10251 | 654.06 |
| 10252 | 3597.9 |
| 10253 | 1444.8000000000002 |
| 10254 | 556.62 |
| 10255 | 2490.5 |