USE tpch1;
select p_brand, sum(l_quantity) tot_qty,
avg(l_quantity) avg_qty
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
Brand#11	732.00	25.241379
Brand#12	986.00	28.171429
Brand#13	814.00	25.437500
Brand#14	704.00	26.074074
Brand#15	580.00	23.200000
Brand#21	664.00	25.538462
Brand#22	518.00	22.521739
Brand#23	964.00	28.352941
Brand#24	460.00	20.000000
Brand#25	632.00	25.280000
Brand#31	674.00	28.083333
Brand#32	653.00	25.115385
Brand#33	710.00	25.357143
Brand#34	414.00	23.000000
Brand#35	516.00	19.846154
Brand#41	797.00	29.518519
Brand#42	1003.00	30.393939
Brand#43	823.00	23.514286
Brand#44	1026.00	27.729730
Brand#45	435.00	21.750000
Brand#51	739.00	25.482759
Brand#52	880.00	28.387097
Brand#53	837.00	24.617647
Brand#54	1126.00	30.432432
Brand#55	525.00	21.000000