| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !select_default -- |
| 1 10 100 1.5 cat1 |
| 2 20 200 3 cat2 |
| 3 30 300 4.5 cat0 |
| 4 40 400 6 cat1 |
| 5 50 500 7.5 cat2 |
| 6 60 600 9 cat0 |
| 7 70 700 10.5 cat1 |
| 8 80 800 12 cat2 |
| 9 90 900 13.5 cat0 |
| 10 100 1000 15 cat1 |
| |
| -- !select_sum_all -- |
| 550 |
| |
| -- !select_sum_group -- |
| cat0 180 |
| cat1 220 |
| cat2 150 |
| |
| -- !select_sum_multiple -- |
| cat0 180 180 |
| cat1 220 220 |
| cat2 150 150 |
| |
| -- !select_sum_with_null -- |
| 550 |
| |
| -- !select_sum_group_with_null -- |
| cat0 180 |
| cat1 220 |
| cat2 150 |
| |
| -- !select_avg_all -- |
| 9.75 |
| |
| -- !select_avg_group -- |
| cat0 11.25 11.25 |
| cat1 8.25 8.25 |
| cat2 9.75 9.75 |
| |
| -- !select_window_partition -- |
| 3 cat0 30 180 |
| 6 cat0 60 180 |
| 9 cat0 90 180 |
| 1 cat1 10 220 |
| 4 cat1 40 220 |
| 7 cat1 70 220 |
| 10 cat1 100 220 |
| 2 cat2 20 150 |
| 5 cat2 50 150 |
| 8 cat2 80 150 |
| |
| -- !select_window_order -- |
| 3 cat0 30 30 |
| 6 cat0 60 90 |
| 9 cat0 90 180 |
| 1 cat1 10 10 |
| 4 cat1 40 50 |
| 7 cat1 70 120 |
| 10 cat1 100 220 |
| 2 cat2 20 20 |
| 5 cat2 50 70 |
| 8 cat2 80 150 |
| |
| -- !select_window_rows -- |
| 3 cat0 30 90 |
| 6 cat0 60 180 |
| 9 cat0 90 150 |
| 1 cat1 10 50 |
| 4 cat1 40 120 |
| 7 cat1 70 210 |
| 10 cat1 100 170 |
| 2 cat2 20 70 |
| 5 cat2 50 150 |
| 8 cat2 80 130 |
| |
| -- !select_global_1 -- |
| 550 |
| |
| -- !select_global_2 -- |
| cat0 180 |
| cat1 220 |
| cat2 150 |
| |
