Northwind › Views
Order Details Extended view
2155 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| OrderID | ProductID | ProductName | UnitPrice | Quantity | Discount | ExtendedPrice |
|---|---|---|---|---|---|---|
| 10265 | 17 | Alice Mutton | 31.2 | 30 | 0.0 | 936.0 |
| 10279 | 17 | Alice Mutton | 31.2 | 15 | 0.25 | 351.0 |
| 10294 | 17 | Alice Mutton | 31.2 | 15 | 0.0 | 468.0 |
| 10302 | 17 | Alice Mutton | 31.2 | 40 | 0.0 | 1248.0 |
| 10319 | 17 | Alice Mutton | 31.2 | 8 | 0.0 | 249.6 |
| 10338 | 17 | Alice Mutton | 31.2 | 20 | 0.0 | 624.0 |
| 10339 | 17 | Alice Mutton | 31.2 | 70 | 0.05 | 2074.8 |
| 10346 | 17 | Alice Mutton | 31.2 | 36 | 0.1 | 1010.88 |
| 10415 | 17 | Alice Mutton | 31.2 | 2 | 0.0 | 62.4 |
| 10430 | 17 | Alice Mutton | 31.2 | 45 | 0.2 | 1123.2 |
| 10431 | 17 | Alice Mutton | 31.2 | 50 | 0.25 | 1170.0 |
| 10444 | 17 | Alice Mutton | 31.2 | 10 | 0.0 | 312.0 |
| 10523 | 17 | Alice Mutton | 39.0 | 25 | 0.1 | 877.5 |
| 10530 | 17 | Alice Mutton | 39.0 | 40 | 0.0 | 1560.0 |
| 10550 | 17 | Alice Mutton | 39.0 | 8 | 0.1 | 280.8 |
| 10564 | 17 | Alice Mutton | 39.0 | 16 | 0.05 | 592.8 |
| 10573 | 17 | Alice Mutton | 39.0 | 18 | 0.0 | 702.0 |
| 10607 | 17 | Alice Mutton | 39.0 | 100 | 0.0 | 3900.0 |
| 10686 | 17 | Alice Mutton | 39.0 | 30 | 0.2 | 936.0 |
| 10696 | 17 | Alice Mutton | 39.0 | 20 | 0.0 | 780.0 |
| 10698 | 17 | Alice Mutton | 39.0 | 8 | 0.05 | 296.4 |
| 10714 | 17 | Alice Mutton | 39.0 | 27 | 0.25 | 789.75 |
| 10727 | 17 | Alice Mutton | 39.0 | 20 | 0.05 | 741.0 |
| 10773 | 17 | Alice Mutton | 39.0 | 33 | 0.0 | 1287.0 |
| 10795 | 17 | Alice Mutton | 39.0 | 35 | 0.25 | 1023.75 |