#
# Test case migrated from regression test suite:
# ./mysql/queries/nightly/alltest/test102/q5.3.1.sql
#
# Author: Susil, susil.behera@mariadb.com
#

-- source ../include/have_columnstore.inc

USE tpch1;

select l_shipdate Revenue_day, 
		l_discount district,
		max(l_shipdate) Latest_date,  
		sum(l_extendedprice) Total_Revenue, 
count(*) Sales_items
from lineitem
group by l_shipdate, l_discount
order by 1,2;