| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !select_data -- |
| 1 A 10 10.5 apple |
| 2 A \N 20.3 banana |
| 3 A 30 \N \N |
| 4 A \N \N cherry |
| 5 B 40 40.2 \N |
| 6 B \N \N \N |
| 7 B 60 60.8 date |
| 8 C \N \N \N |
| 9 C \N \N \N |
| 10 C \N \N \N |
| |
| -- !count_null_all -- |
| 4 |
| |
| -- !count_null_group -- |
| A 2 |
| B 2 |
| C 0 |
| |
| -- !sum_null_all -- |
| 131.8 |
| |
| -- !sum_null_group -- |
| A 30.8 |
| B 101 |
| C \N |
| |
| -- !first_nonnull_all -- |
| apple |
| |
| -- !first_nonnull_group -- |
| A apple |
| B date |
| C \N |
| |
| -- !null_count_all -- |
| 6 |
| |
| -- !null_count_group -- |
| A 2 |
| B 1 |
| C 3 |
| |
| -- !avg_coalesce_all -- |
| 32.95 |
| |
| -- !avg_coalesce_group -- |
| A 15.4 |
| B 50.5 |
| C \N |
| |
| -- !all_null_count -- |
| 0 |
| |
| -- !all_null_sum -- |
| \N |
| |
| -- !empty_count -- |
| 0 |
| |
| -- !empty_sum -- |
| \N |
| |
