USE tpch1;
select l_shipdate, sum(l_extendedprice), avg(p_retailprice) 
from part, lineitem
where l_shipdate between '1993-01-01' and '1994-06-30' 
and p_retailprice >= 2095
and p_size <= 5 
and p_partkey = l_partkey
group by l_shipdate
order by 1;
l_shipdate	sum(l_extendedprice)	avg(p_retailprice)
1993-02-07	71263.66	2095.990000
1993-07-26	60783.71	2095.990000
1993-10-09	14671.93	2095.990000