USE tpch1;
select  n_name, sum(l_quantity), sum(l_extendedprice),
max(l_orderkey),
sum(l_partkey),
avg(l_quantity),
min(l_commitdate),
count(l_linestatus)	
from nation, lineitem
where l_quantity = 5 and l_partkey < 100
and n_nationkey = l_linenumber
group by n_name order by n_name;
n_name	sum(l_quantity)	sum(l_extendedprice)	max(l_orderkey)	sum(l_partkey)	avg(l_quantity)	min(l_commitdate)	count(l_linestatus)
ARGENTINA	80.00	75593.15	5530822	718	5.000000	1992-05-19	16
BRAZIL	45.00	43097.35	4346432	519	5.000000	1992-03-30	9
CANADA	40.00	37496.35	5744288	299	5.000000	1993-09-13	8
EGYPT	50.00	47887.70	4874051	577	5.000000	1993-12-11	10
ETHIOPIA	30.00	28626.50	5557697	325	5.000000	1992-11-19	6
FRANCE	15.00	14150.60	5954052	130	5.000000	1992-07-23	3
GERMANY	10.00	9545.50	5435525	109	5.000000	1993-07-03	2