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-07-16 | 10248 | 440.0 |
| 1996-07-10 | 10249 | 1863.4 |
| 1996-07-12 | 10250 | 1552.6000000000001 |
| 1996-07-15 | 10251 | 654.0600000000001 |
| 1996-07-11 | 10252 | 3597.9 |
| 1996-07-16 | 10253 | 1444.8 |
| 1996-07-23 | 10254 | 556.62 |
| 1996-07-15 | 10255 | 2490.5 |
| 1996-07-17 | 10256 | 517.8 |
| 1996-07-22 | 10257 | 1119.9 |
| 1996-07-23 | 10258 | 1614.88 |
| 1996-07-25 | 10259 | 100.8 |
| 1996-07-29 | 10260 | 1504.65 |
| 1996-07-30 | 10261 | 448.0 |
| 1996-07-25 | 10262 | 584.0 |
| 1996-07-31 | 10263 | 1873.8 |
| 1996-08-23 | 10264 | 695.63 |
| 1996-08-12 | 10265 | 1176.0 |
| 1996-07-31 | 10266 | 346.56 |
| 1996-08-06 | 10267 | 3536.6 |
| 1996-08-02 | 10268 | 1101.2 |
| 1996-08-09 | 10269 | 642.2 |
| 1996-08-02 | 10270 | 1376.0 |
| 1996-08-30 | 10271 | 48.0 |
| 1996-08-06 | 10272 | 1456.0 |