-- 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