| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !select_data -- |
| 1 2024-01-01 North Laptop 1200 2 Alice |
| 2 2024-01-02 North Mouse 25 10 Alice |
| 3 2024-01-03 North Keyboard 75 5 Bob |
| 4 2024-01-04 South Laptop 1150 1 Charlie |
| 5 2024-01-05 South Monitor 300 3 Charlie |
| 6 2024-01-06 South Mouse 20 15 David |
| 7 2024-01-07 East Laptop 1300 2 Eve |
| 8 2024-01-08 East Keyboard 80 4 Eve |
| 9 2024-01-09 East Monitor 320 2 Frank |
| 10 2024-01-10 West Laptop 1250 3 Grace |
| 11 2024-01-11 West Mouse 22 12 Grace |
| 12 2024-01-12 West Keyboard 70 6 Henry |
| 13 2024-01-13 North Monitor 310 2 Alice |
| 14 2024-01-14 South Keyboard 78 3 Charlie |
| 15 2024-01-15 East Mouse 24 8 Eve |
| |
| -- !window_partition_by -- |
| 7 East 1300 1300 |
| 8 East 80 1380 |
| 9 East 320 1700 |
| 15 East 24 1724 |
| 1 North 1200 1200 |
| 2 North 25 1225 |
| 3 North 75 1300 |
| 13 North 310 1610 |
| 4 South 1150 1150 |
| 5 South 300 1450 |
| 6 South 20 1470 |
| 14 South 78 1548 |
| 10 West 1250 1250 |
| 11 West 22 1272 |
| 12 West 70 1342 |
| |
| -- !window_order_by -- |
| 1 2024-01-01 1200 1200 1 |
| 2 2024-01-02 25 1225 2 |
| 3 2024-01-03 75 1300 3 |
| 4 2024-01-04 1150 2450 4 |
| 5 2024-01-05 300 2750 5 |
| 6 2024-01-06 20 2770 6 |
| 7 2024-01-07 1300 4070 7 |
| 8 2024-01-08 80 4150 8 |
| 9 2024-01-09 320 4470 9 |
| 10 2024-01-10 1250 5720 10 |
| 11 2024-01-11 22 5742 11 |
| 12 2024-01-12 70 5812 12 |
| 13 2024-01-13 310 6122 13 |
| 14 2024-01-14 78 6200 14 |
| 15 2024-01-15 24 6224 15 |
| |
| -- !window_multi_partition -- |
| East Laptop 1300 1300 3650 1300 |
| East Keyboard 80 1380 155 690 |
| East Monitor 320 1700 620 566.6666666666666 |
| East Mouse 24 1724 91 431 |
| North Laptop 1200 1200 1200 1200 |
| North Mouse 25 1225 25 612.5 |
| North Keyboard 75 1300 75 433.3333333333333 |
| North Monitor 310 1610 930 402.5 |
| South Laptop 1150 1150 2350 1150 |
| South Monitor 300 1450 300 725 |
| South Mouse 20 1470 45 490 |
| South Keyboard 78 1548 303 387 |
| West Laptop 1250 1250 4900 1250 |
| West Mouse 22 1272 67 636 |
| West Keyboard 70 1342 225 447.3333333333333 |
| |
| -- !window_rows_between -- |
| 1 2024-01-01 1200 1200 |
| 2 2024-01-02 25 1225 |
| 3 2024-01-03 75 1300 |
| 4 2024-01-04 1150 1250 |
| 5 2024-01-05 300 1525 |
| 6 2024-01-06 20 1470 |
| 7 2024-01-07 1300 1620 |
| 8 2024-01-08 80 1400 |
| 9 2024-01-09 320 1700 |
| 10 2024-01-10 1250 1650 |
| 11 2024-01-11 22 1592 |
| 12 2024-01-12 70 1342 |
| 13 2024-01-13 310 402 |
| 14 2024-01-14 78 458 |
| 15 2024-01-15 24 412 |
| |
| -- !window_unbounded -- |
| East 2024-01-07 1300 1300 |
| East 2024-01-08 80 1380 |
| East 2024-01-09 320 1700 |
| East 2024-01-15 24 1724 |
| North 2024-01-01 1200 1200 |
| North 2024-01-02 25 1225 |
| North 2024-01-03 75 1300 |
| North 2024-01-13 310 1610 |
| South 2024-01-04 1150 1150 |
| South 2024-01-05 300 1450 |
| South 2024-01-06 20 1470 |
| South 2024-01-14 78 1548 |
| West 2024-01-10 1250 1250 |
| West 2024-01-11 22 1272 |
| West 2024-01-12 70 1342 |
| |
| -- !window_salesperson -- |
| Alice 2024-01-01 1200 1200 1 |
| Alice 2024-01-02 25 1225 2 |
| Alice 2024-01-13 310 1535 3 |
| Bob 2024-01-03 75 75 1 |
| Charlie 2024-01-04 1150 1150 1 |
| Charlie 2024-01-05 300 1450 2 |
| Charlie 2024-01-14 78 1528 3 |
| David 2024-01-06 20 20 1 |
| Eve 2024-01-07 1300 1300 1 |
| Eve 2024-01-08 80 1380 2 |
| Eve 2024-01-15 24 1404 3 |
| Frank 2024-01-09 320 320 1 |
| Grace 2024-01-10 1250 1250 1 |
| Grace 2024-01-11 22 1272 2 |
| Henry 2024-01-12 70 70 1 |
| |
| -- !window_vs_group_by -- |
| East 1300 1724 1724 |
| East 80 1724 1724 |
| East 320 1724 1724 |
| East 24 1724 1724 |
| North 1200 1610 1610 |
| North 25 1610 1610 |
| North 75 1610 1610 |
| North 310 1610 1610 |
| South 1150 1548 1548 |
| South 300 1548 1548 |
| South 20 1548 1548 |
| South 78 1548 1548 |
| West 1250 1342 1342 |
| West 22 1342 1342 |
| West 70 1342 1342 |
| |
| -- !window_multiple_specs -- |
| Keyboard 2024-01-03 75 75 433.3333333333333 1 |
| Keyboard 2024-01-08 80 155 518.75 2 |
| Keyboard 2024-01-12 70 225 484.3333333333333 3 |
| Keyboard 2024-01-14 78 303 442.8571428571428 4 |
| Laptop 2024-01-01 1200 1200 1200 1 |
| Laptop 2024-01-04 1150 2350 612.5 2 |
| Laptop 2024-01-07 1300 3650 581.4285714285714 3 |
| Laptop 2024-01-10 1250 4900 572 4 |
| Monitor 2024-01-05 300 300 550 1 |
| Monitor 2024-01-09 320 620 496.6666666666667 2 |
| Monitor 2024-01-13 310 930 470.9230769230769 3 |
| Mouse 2024-01-02 25 25 612.5 1 |
| Mouse 2024-01-06 20 45 461.6666666666667 2 |
| Mouse 2024-01-11 22 67 522 3 |
| Mouse 2024-01-15 24 91 414.9333333333333 4 |
| |
| -- !window_complex_order -- |
| East Laptop 1300 2 1300 |
| East Monitor 320 2 1620 |
| East Keyboard 80 4 1700 |
| East Mouse 24 8 1724 |
| North Laptop 1200 2 1200 |
| North Monitor 310 2 1510 |
| North Keyboard 75 5 1585 |
| North Mouse 25 10 1610 |
| South Laptop 1150 1 1150 |
| South Monitor 300 3 1450 |
| South Keyboard 78 3 1528 |
| South Mouse 20 15 1548 |
| West Laptop 1250 3 1250 |
| West Keyboard 70 6 1320 |
| West Mouse 22 12 1342 |
| |
| -- !window_with_where -- |
| East Laptop 1300 1300 |
| East Keyboard 80 1380 |
| East Monitor 320 1700 |
| North Laptop 1200 1200 |
| North Keyboard 75 1275 |
| North Monitor 310 1585 |
| South Laptop 1150 1150 |
| South Monitor 300 1450 |
| South Keyboard 78 1528 |
| West Laptop 1250 1250 |
| West Keyboard 70 1320 |
| |
| -- !window_nested -- |
| East 2024-01-07 1300 1300 0 |
| East 2024-01-08 80 1380 1300 |
| East 2024-01-09 320 1700 1380 |
| East 2024-01-15 24 1724 1700 |
| North 2024-01-01 1200 1200 0 |
| North 2024-01-02 25 1225 1200 |
| North 2024-01-03 75 1300 1225 |
| North 2024-01-13 310 1610 1300 |
| South 2024-01-04 1150 1150 0 |
| South 2024-01-05 300 1450 1150 |
| South 2024-01-06 20 1470 1450 |
| South 2024-01-14 78 1548 1470 |
| West 2024-01-10 1250 1250 0 |
| West 2024-01-11 22 1272 1250 |
| West 2024-01-12 70 1342 1272 |
| |
| -- !window_range_frame -- |
| 1 2024-01-01 1200 1225 |
| 2 2024-01-02 25 1300 |
| 3 2024-01-03 75 1250 |
| 4 2024-01-04 1150 1525 |
| 5 2024-01-05 300 1470 |
| 6 2024-01-06 20 1620 |
| 7 2024-01-07 1300 1400 |
| 8 2024-01-08 80 1700 |
| 9 2024-01-09 320 1650 |
| 10 2024-01-10 1250 1592 |
| 11 2024-01-11 22 1342 |
| 12 2024-01-12 70 402 |
| 13 2024-01-13 310 458 |
| 14 2024-01-14 78 412 |
| 15 2024-01-15 24 102 |
| |
| -- !window_sparse -- |
| A 100 100 1 |
| A 200 300 2 |
| B 300 300 1 |
| C 400 400 1 |
| C 500 900 2 |
| C 600 1500 3 |
| |
| -- !window_first_value -- |
| East 2024-01-07 1300 1300 |
| East 2024-01-08 80 1300 |
| East 2024-01-09 320 1300 |
| East 2024-01-15 24 1300 |
| North 2024-01-01 1200 1200 |
| North 2024-01-02 25 1200 |
| North 2024-01-03 75 1200 |
| North 2024-01-13 310 1200 |
| South 2024-01-04 1150 1150 |
| South 2024-01-05 300 1150 |
| South 2024-01-06 20 1150 |
| South 2024-01-14 78 1150 |
| West 2024-01-10 1250 1250 |
| West 2024-01-11 22 1250 |
| West 2024-01-12 70 1250 |
| |
| -- !window_with_nulls -- |
| A 10 10 1 |
| A \N 10 1 |
| A 30 40 2 |
| B \N 0 0 |
| B 50 50 1 |
| B \N 50 1 |
| |
| -- !window_large_dataset -- |
| 0 20 498.75 |
| 1 20 514.5 |
| 2 20 530.25 |
| 3 20 546 |
| 4 20 561.75 |
| |
