USE tpch1;
select p_brand, sum(l_quantity) tot_qty,
avg(l_quantity) avg_qty, count(*)
from part, lineitem
where l_shipdate between '1996-04-01' and '1996-04-14'
and p_size = 5
and p_partkey = l_partkey
group by p_brand
order by 1;
p_brand	tot_qty	avg_qty	count(*)
Brand#11	732.00	25.241379	29
Brand#12	986.00	28.171429	35
Brand#13	814.00	25.437500	32
Brand#14	704.00	26.074074	27
Brand#15	580.00	23.200000	25
Brand#21	664.00	25.538462	26
Brand#22	518.00	22.521739	23
Brand#23	964.00	28.352941	34
Brand#24	460.00	20.000000	23
Brand#25	632.00	25.280000	25
Brand#31	674.00	28.083333	24
Brand#32	653.00	25.115385	26
Brand#33	710.00	25.357143	28
Brand#34	414.00	23.000000	18
Brand#35	516.00	19.846154	26
Brand#41	797.00	29.518519	27
Brand#42	1003.00	30.393939	33
Brand#43	823.00	23.514286	35
Brand#44	1026.00	27.729730	37
Brand#45	435.00	21.750000	20
Brand#51	739.00	25.482759	29
Brand#52	880.00	28.387097	31
Brand#53	837.00	24.617647	34
Brand#54	1126.00	30.432432	37
Brand#55	525.00	21.000000	25