USE tpch1;
select  n_name, l_commitdate, sum(s_acctbal) sum_bal, 
sum(l_extendedprice) sum_price, min(s_suppkey) minskey, count(*)
from nation, supplier, lineitem
where s_nationkey in (1,2)
and l_commitdate between '1998-01-01' and '1998-01-07'
and n_nationkey = s_nationkey
and s_suppkey = l_suppkey
group by n_name, l_commitdate
order by 1, 2;
n_name	l_commitdate	sum_bal	sum_price	minskey	count(*)
ARGENTINA	1998-01-01	420067.00	4072692.43	297	107
ARGENTINA	1998-01-02	380111.44	3281853.04	297	79
ARGENTINA	1998-01-03	467853.91	3947219.19	127	104
ARGENTINA	1998-01-04	473136.85	3390840.12	29	99
ARGENTINA	1998-01-05	467911.51	3991029.29	3	103
ARGENTINA	1998-01-06	472630.72	4241582.98	203	114
ARGENTINA	1998-01-07	468276.49	3656839.92	3	108
BRAZIL	1998-01-01	343870.69	3015885.44	125	87
BRAZIL	1998-01-02	387866.16	4210977.99	125	100
BRAZIL	1998-01-03	516726.25	4688509.72	195	116
BRAZIL	1998-01-04	493045.19	3829683.25	103	98
BRAZIL	1998-01-05	410965.66	3653171.10	21	90
BRAZIL	1998-01-06	445486.45	3959481.31	210	98
BRAZIL	1998-01-07	438111.78	3416259.54	528	87