Northwind › Views
Summary of Sales by Year view
809 rows. A view stores a SELECT statement, not rows: each time you open it, SQLite runs the query again.
| ShippedDate | OrderID | Subtotal |
|---|---|---|
| 1996-08-12 | 10273 | 2037.28 |
| 1996-08-16 | 10274 | 538.6 |
| 1996-08-09 | 10275 | 291.84000000000003 |
| 1996-08-14 | 10276 | 420.0 |
| 1996-08-13 | 10277 | 1200.8 |
| 1996-08-16 | 10278 | 1488.8 |
| 1996-08-16 | 10279 | 351.0 |
| 1996-09-12 | 10280 | 613.2 |
| 1996-08-21 | 10281 | 86.5 |
| 1996-08-21 | 10282 | 155.4 |
| 1996-08-23 | 10283 | 1414.8 |
| 1996-08-27 | 10284 | 1170.38 |
| 1996-08-26 | 10285 | 1743.36 |
| 1996-08-30 | 10286 | 3016.0 |
| 1996-08-28 | 10287 | 819.0 |
| 1996-09-03 | 10288 | 80.1 |
| 1996-08-28 | 10289 | 479.4 |
| 1996-09-03 | 10290 | 2169.0 |
| 1996-09-04 | 10291 | 497.52 |
| 1996-09-02 | 10292 | 1296.0 |
| 1996-09-11 | 10293 | 848.7 |
| 1996-09-05 | 10294 | 1887.6000000000001 |
| 1996-09-10 | 10295 | 121.6 |
| 1996-09-11 | 10296 | 1050.6 |
| 1996-09-10 | 10297 | 1420.0 |