USE tpch1; select count(l_orderkey), min(l_orderkey), max(l_orderkey) , sum(l_orderkey), avg(l_orderkey) from lineitem; count(l_orderkey) min(l_orderkey) max(l_orderkey) sum(l_orderkey) avg(l_orderkey) 6001215 1 6000000 18005322964949 3000279.6042 select count(l_partkey), min(l_partkey), max(l_partkey) , sum(l_partkey), avg(l_partkey) from lineitem; count(l_partkey) min(l_partkey) max(l_partkey) sum(l_partkey) avg(l_partkey) 6001215 1 200000 600229457837 100017.9893 select count(l_suppkey), min(l_suppkey), max(l_suppkey) , sum(l_suppkey), avg(l_suppkey) from lineitem; count(l_suppkey) min(l_suppkey) max(l_suppkey) sum(l_suppkey) avg(l_suppkey) 6001215 1 10000 30009691369 5000.6026 select count(l_linenumber), min(l_linenumber), max(l_linenumber) , sum(l_linenumber), avg(l_linenumber) from lineitem; count(l_linenumber) min(l_linenumber) max(l_linenumber) sum(l_linenumber) avg(l_linenumber) 6001215 1 7 18007100 3.0006 select count(l_quantity), min(l_quantity), max(l_quantity) , sum(l_quantity), avg(l_quantity) from lineitem; count(l_quantity) min(l_quantity) max(l_quantity) sum(l_quantity) avg(l_quantity) 6001215 1.00 50.00 153078795.00 25.507967 select count(l_extendedprice), min(l_extendedprice), max(l_extendedprice) , sum(l_extendedprice), avg(l_extendedprice) from lineitem; count(l_extendedprice) min(l_extendedprice) max(l_extendedprice) sum(l_extendedprice) avg(l_extendedprice) 6001215 901.00 104949.50 229577310901.20 38255.138485 select count(l_discount), min(l_discount), max(l_discount) , sum(l_discount), avg(l_discount) from lineitem; count(l_discount) min(l_discount) max(l_discount) sum(l_discount) avg(l_discount) 6001215 0.00 0.10 300057.33 0.049999 select count(l_tax), min(l_tax), max(l_tax) , sum(l_tax), avg(l_tax) from lineitem; count(l_tax) min(l_tax) max(l_tax) sum(l_tax) avg(l_tax) 6001215 0.00 0.08 240129.67 0.040014 select count(l_returnflag), min(l_returnflag), max(l_returnflag) from lineitem; count(l_returnflag) min(l_returnflag) max(l_returnflag) 6001215 A R select count(l_linestatus), min(l_linestatus), max(l_linestatus) from lineitem; count(l_linestatus) min(l_linestatus) max(l_linestatus) 6001215 F O select count(l_shipdate), min(l_shipdate), max(l_shipdate) from lineitem; count(l_shipdate) min(l_shipdate) max(l_shipdate) 6001215 1992-01-02 1998-12-01 select count(l_commitdate), min(l_commitdate), max(l_commitdate) from lineitem; count(l_commitdate) min(l_commitdate) max(l_commitdate) 6001215 1992-01-31 1998-10-31 select count(l_receiptdate), min(l_receiptdate), max(l_receiptdate) from lineitem; count(l_receiptdate) min(l_receiptdate) max(l_receiptdate) 6001215 1992-01-04 1998-12-31 select count(*) from lineitem; count(*) 6001215 select count(o_orderkey), min(o_orderkey), max(o_orderkey) , sum(o_orderkey), avg(o_orderkey) from orders; count(o_orderkey) min(o_orderkey) max(o_orderkey) sum(o_orderkey) avg(o_orderkey) 1500000 1 6000000 4499987250000 2999991.5000 select count(o_custkey), min(o_custkey), max(o_custkey) , sum(o_custkey), avg(o_custkey) from orders; count(o_custkey) min(o_custkey) max(o_custkey) sum(o_custkey) avg(o_custkey) 1500000 1 149999 112509060862 75006.0406 select count(o_orderstatus), min(o_orderstatus), max(o_orderstatus) from orders; count(o_orderstatus) min(o_orderstatus) max(o_orderstatus) 1500000 F P select count(o_totalprice), min(o_totalprice), max(o_totalprice) , sum(o_totalprice), avg(o_totalprice) from orders; count(o_totalprice) min(o_totalprice) max(o_totalprice) sum(o_totalprice) avg(o_totalprice) 1500000 857.71 555285.16 226829306447.46 151219.537632 select count(o_orderdate), min(o_orderdate), max(o_orderdate) from orders; count(o_orderdate) min(o_orderdate) max(o_orderdate) 1500000 1992-01-01 1998-08-02 select count(o_orderpriority), min(o_orderpriority), max(o_orderpriority) from orders; count(o_orderpriority) min(o_orderpriority) max(o_orderpriority) 1500000 1-URGENT 5-LOW select count(o_clerk), min(o_clerk), max(o_clerk) from orders; count(o_clerk) min(o_clerk) max(o_clerk) 1500000 Clerk#000000001 Clerk#000001000 select count(o_shippriority), min(o_shippriority), max(o_shippriority) from orders; count(o_shippriority) min(o_shippriority) max(o_shippriority) 1500000 0 0 select count(o_comment), min(o_comment), max(o_comment) from orders; count(o_comment) min(o_comment) max(o_comment) 1500000 about the accounts zzle? furiously ironic instructions among the unusual t select count(*) from orders; count(*) 1500000 select count(n_nationkey), min(n_nationkey), max(n_nationkey) , sum(n_nationkey), avg(n_nationkey) from nation; count(n_nationkey) min(n_nationkey) max(n_nationkey) sum(n_nationkey) avg(n_nationkey) 25 0 24 300 12.0000 select count(n_name), min(n_name), max(n_name) from nation; count(n_name) min(n_name) max(n_name) 25 ALGERIA VIETNAM select count(n_regionkey), min(n_regionkey), max(n_regionkey) , sum(n_regionkey), avg(n_regionkey) from nation; count(n_regionkey) min(n_regionkey) max(n_regionkey) sum(n_regionkey) avg(n_regionkey) 25 0 4 50 2.0000 select count(n_comment), min(n_comment), max(n_comment) from nation; count(n_comment) min(n_comment) max(n_comment) 25 haggle. carefully final deposits detect slyly agai y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be select count(*) from nation; count(*) 25 select count(r_regionkey), min(r_regionkey), max(r_regionkey) , sum(r_regionkey), avg(r_regionkey) from region; count(r_regionkey) min(r_regionkey) max(r_regionkey) sum(r_regionkey) avg(r_regionkey) 5 0 4 10 2.0000 select count(r_name), min(r_name), max(r_name) from region; count(r_name) min(r_name) max(r_name) 5 AFRICA MIDDLE EAST select count(r_comment), min(r_comment), max(r_comment) from region; count(r_comment) min(r_comment) max(r_comment) 5 ges. thinly even pinto beans ca uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl select count(*) from region; count(*) 5 select count(c_custkey), min(c_custkey), max(c_custkey) , sum(c_custkey), avg(c_custkey) from customer; count(c_custkey) min(c_custkey) max(c_custkey) sum(c_custkey) avg(c_custkey) 150000 1 150000 11250075000 75000.5000 select count(c_name), min(c_name), max(c_name) from customer; count(c_name) min(c_name) max(c_name) 150000 Customer#000000001 Customer#000150000 select count(c_address), min(c_address), max(c_address) from customer; count(c_address) min(c_address) max(c_address) 150000 2uZwVhQvwA zzZWJlpDD8eDh8BaXld7BMBX0w select count(c_nationkey), min(c_nationkey), max(c_nationkey) , sum(c_nationkey), avg(c_nationkey) from customer; count(c_nationkey) min(c_nationkey) max(c_nationkey) sum(c_nationkey) avg(c_nationkey) 150000 0 24 1801005 12.0067 select count(c_phone), min(c_phone), max(c_phone) from customer; count(c_phone) min(c_phone) max(c_phone) 150000 10-100-106-1617 34-999-618-6881 select count(c_acctbal), min(c_acctbal), max(c_acctbal) , sum(c_acctbal), avg(c_acctbal) from customer; count(c_acctbal) min(c_acctbal) max(c_acctbal) sum(c_acctbal) avg(c_acctbal) 150000 -999.99 9999.99 674326849.74 4495.512332 select count(c_mktsegment), min(c_mktsegment), max(c_mktsegment) from customer; count(c_mktsegment) min(c_mktsegment) max(c_mktsegment) 150000 AUTOMOBILE MACHINERY select count(c_comment), min(c_comment), max(c_comment) from customer; count(c_comment) min(c_comment) max(c_comment) 150000 about the accounts nag slyly ironic theodolites. furiously i zzle. blithely regular instructions cajol select count(*) from customer; count(*) 150000 select count(s_suppkey), min(s_suppkey), max(s_suppkey) , sum(s_suppkey), avg(s_suppkey) from supplier; count(s_suppkey) min(s_suppkey) max(s_suppkey) sum(s_suppkey) avg(s_suppkey) 10000 1 10000 50005000 5000.5000 select count(s_name), min(s_name), max(s_name) from supplier; count(s_name) min(s_name) max(s_name) 10000 Supplier#000000001 Supplier#000010000 select count(s_address), min(s_address), max(s_address) from supplier; count(s_address) min(s_address) max(s_address) 10000 9aW1wwnBJJPnCx,nox0MA48Y0zpI1IeVfYZ ZZZwPfP9X1xcLQ select count(s_nationkey), min(s_nationkey), max(s_nationkey) , sum(s_nationkey), avg(s_nationkey) from supplier; count(s_nationkey) min(s_nationkey) max(s_nationkey) sum(s_nationkey) avg(s_nationkey) 10000 0 24 119353 11.9353 select count(s_phone), min(s_phone), max(s_phone) from supplier; count(s_phone) min(s_phone) max(s_phone) 10000 10-102-116-6785 34-998-900-4911 select count(s_acctbal), min(s_acctbal), max(s_acctbal) from supplier; count(s_acctbal) min(s_acctbal) max(s_acctbal) 10000 -998.22 9999.72 select count(s_comment), min(s_comment), max(s_comment) from supplier; count(s_comment) min(s_comment) max(s_comment) 10000 about the blithely express foxes. bli zzle furiously. bold accounts haggle furiously ironic excuses. fur select count(*) from supplier; count(*) 10000 select count(ps_partkey), min(ps_partkey), max(ps_partkey) , sum(ps_partkey), avg(ps_partkey) from partsupp; count(ps_partkey) min(ps_partkey) max(ps_partkey) sum(ps_partkey) avg(ps_partkey) 800000 1 200000 80000400000 100000.5000 select count(ps_suppkey), min(ps_suppkey), max(ps_suppkey) , sum(ps_suppkey), avg(ps_suppkey) from partsupp; count(ps_suppkey) min(ps_suppkey) max(ps_suppkey) sum(ps_suppkey) avg(ps_suppkey) 800000 1 10000 4000400000 5000.5000 select count(ps_availqty), min(ps_availqty), max(ps_availqty) , sum(ps_availqty), avg(ps_availqty) from partsupp; count(ps_availqty) min(ps_availqty) max(ps_availqty) sum(ps_availqty) avg(ps_availqty) 800000 1 9999 4002581547 5003.2269 select count(ps_supplycost), min(ps_supplycost), max(ps_supplycost) , sum(ps_supplycost), avg(ps_supplycost) from partsupp; count(ps_supplycost) min(ps_supplycost) max(ps_supplycost) sum(ps_supplycost) avg(ps_supplycost) 800000 1.00 1000.00 400420638.54 500.525798 select count(ps_comment), min(ps_comment), max(ps_comment) from partsupp; count(ps_comment) min(ps_comment) max(ps_comment) 800000 about the accounts are furiously slyly pending escapades. fluffily pending packages sublate quickly carefully final dependencies. regular ideas maint zzle. unusual decoys detect slyly blithely express frays. furiously ironic packages about the bold accounts are close requests. slowly silent reque select count(*) from partsupp; count(*) 800000 select count(p_partkey), min(p_partkey), max(p_partkey) , sum(p_partkey), avg(p_partkey) from part; count(p_partkey) min(p_partkey) max(p_partkey) sum(p_partkey) avg(p_partkey) 200000 1 200000 20000100000 100000.5000 select count(p_name), min(p_name), max(p_name) from part; count(p_name) min(p_name) max(p_name) 200000 almond antique blue royal burnished yellow white seashell lavender black select count(p_mfgr), min(p_mfgr), max(p_mfgr) from part; count(p_mfgr) min(p_mfgr) max(p_mfgr) 200000 Manufacturer#1 Manufacturer#5 select count(p_brand), min(p_brand), max(p_brand) from part; count(p_brand) min(p_brand) max(p_brand) 200000 Brand#11 Brand#55 select count(p_type), min(p_type), max(p_type) from part; count(p_type) min(p_type) max(p_type) 200000 ECONOMY ANODIZED BRASS STANDARD POLISHED TIN select count(p_size), min(p_size), max(p_size) , sum(p_size), avg(p_size) from part; count(p_size) min(p_size) max(p_size) sum(p_size) avg(p_size) 200000 1 50 5085421 25.4271 select count(p_container), min(p_container), max(p_container) from part; count(p_container) min(p_container) max(p_container) 200000 JUMBO BAG WRAP PKG select count(p_retailprice), min(p_retailprice), max(p_retailprice) , sum(p_retailprice), avg(p_retailprice) from part; count(p_retailprice) min(p_retailprice) max(p_retailprice) sum(p_retailprice) avg(p_retailprice) 200000 901.00 2098.99 299899200.00 1499.496000 select count(p_comment), min(p_comment), max(p_comment) from part; count(p_comment) min(p_comment) max(p_comment) 200000 abou zzle. quickly si select count(*) from part; count(*) 200000 select count(l_shipinstruct), min(l_shipinstruct), max(l_shipinstruct) from lineitem; count(l_shipinstruct) min(l_shipinstruct) max(l_shipinstruct) 6001215 COLLECT COD TAKE BACK RETURN select count(l_shipmode), min(l_shipmode), max(l_shipmode) from lineitem; count(l_shipmode) min(l_shipmode) max(l_shipmode) 6001215 AIR TRUCK select count(l_comment), min(l_comment), max(l_comment) from lineitem; count(l_comment) min(l_comment) max(l_comment) 6001215 about the zzle? slyly final platelets sleep quickly.