# # Test case migrated from regression test suite: # ./mysql/queries/nightly/alltest/test102/q4.8.9.sql # # Author: Susil, susil.behera@mariadb.com # -- source ../include/have_columnstore.inc USE tpch1; select l_returnflag, l_linestatus, sum(l_quantity) as sum_qty, sum(l_extendedprice) as sum_base_price, avg(l_quantity) as avg_qty, avg(l_extendedprice) as avg_price, avg(l_discount) as avg_disc, count(*) as count_order from lineitem where l_shipdate <= date '1998-09-26' group by l_returnflag, l_linestatus order by l_returnflag, l_linestatus;