select S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY select S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY select S_NAME,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_NATIONKEY select S_NAME,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_NATIONKEY select S_NAME,S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_ACCTBAL select S_NATIONKEY,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_NAME select S_NATIONKEY,S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_ACCTBAL select S_NATIONKEY,S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_ACCTBAL select S_ACCTBAL,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NAME select S_ACCTBAL,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NATIONKEY select S_NAME,S_NATIONKEY,S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_NATIONKEY,S_ACCTBAL select S_NAME,S_ACCTBAL,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_ACCTBAL,S_NATIONKEY select S_NAME,S_ACCTBAL,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_ACCTBAL,S_NATIONKEY select S_NATIONKEY,S_NAME,S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_NAME,S_ACCTBAL select S_NATIONKEY,S_ACCTBAL,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_ACCTBAL,S_NAME select S_ACCTBAL,S_NAME,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NAME,S_NATIONKEY select S_ACCTBAL,S_NAME,S_NATIONKEY,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NAME,S_NATIONKEY select S_ACCTBAL,S_NATIONKEY,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NATIONKEY,S_NAME select PS_SUPPLYCOST,count(*) as cnt from ORDERS,LINEITEM,PARTSUPP where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and PS_SUPPLYCOST=L_EXTENDEDPRICE and L_ORDERKEY=O_ORDERKEY group by PS_SUPPLYCOST select PS_AVAILQTY,count(*) as cnt from ORDERS,LINEITEM,PARTSUPP where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and PS_SUPPLYCOST=L_EXTENDEDPRICE and L_ORDERKEY=O_ORDERKEY group by PS_AVAILQTY select PS_SUPPLYCOST,PS_AVAILQTY,count(*) as cnt from ORDERS,LINEITEM,PARTSUPP where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and PS_SUPPLYCOST=L_EXTENDEDPRICE and L_ORDERKEY=O_ORDERKEY group by PS_SUPPLYCOST,PS_AVAILQTY select PS_AVAILQTY,PS_SUPPLYCOST,count(*) as cnt from ORDERS,LINEITEM,PARTSUPP where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and PS_SUPPLYCOST=L_EXTENDEDPRICE and L_ORDERKEY=O_ORDERKEY group by PS_AVAILQTY,PS_SUPPLYCOST select L_LINENUMBER,count(*) as cnt from CUSTOMER,ORDERS,LINEITEM where C_ACCTBAL in (select C_ACCTBAL from CUSTOMER group by C_ACCTBAL having count(*)=4) and O_TOTALPRICE=L_EXTENDEDPRICE and O_CUSTKEY=C_CUSTKEY group by L_LINENUMBER select L_TAX,count(*) as cnt from CUSTOMER,ORDERS,LINEITEM where C_ACCTBAL in (select C_ACCTBAL from CUSTOMER group by C_ACCTBAL having count(*)=4) and O_TOTALPRICE=L_EXTENDEDPRICE and O_CUSTKEY=C_CUSTKEY group by L_TAX select L_TAX,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_TAX select L_COMMITDATE,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_COMMITDATE select L_LINENUMBER,L_TAX,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_LINENUMBER,L_TAX select L_TAX,L_COMMITDATE,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_TAX,L_COMMITDATE select L_COMMITDATE,L_LINENUMBER,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_COMMITDATE,L_LINENUMBER select L_COMMITDATE,L_TAX,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_COMMITDATE,L_TAX select L_LINENUMBER,L_TAX,L_COMMITDATE,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_LINENUMBER,L_TAX,L_COMMITDATE select L_TAX,L_COMMITDATE,L_LINENUMBER,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_TAX,L_COMMITDATE,L_LINENUMBER select L_COMMITDATE,L_LINENUMBER,L_TAX,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_COMMITDATE,L_LINENUMBER,L_TAX select L_COMMITDATE,L_TAX,L_LINENUMBER,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_COMMITDATE,L_TAX,L_LINENUMBER select L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER select L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX select L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX select L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE select L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE select L_LINENUMBER,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_TAX select L_LINENUMBER,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_TAX select L_LINENUMBER,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_COMMITDATE select L_LINENUMBER,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_COMMITDATE select L_TAX,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_LINENUMBER select L_TAX,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_LINENUMBER select L_TAX,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_COMMITDATE select L_TAX,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_COMMITDATE select L_COMMITDATE,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_LINENUMBER select L_COMMITDATE,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_LINENUMBER select L_COMMITDATE,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_TAX select L_COMMITDATE,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_TAX select L_LINENUMBER,L_TAX,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_TAX,L_COMMITDATE select L_LINENUMBER,L_TAX,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_TAX,L_COMMITDATE select L_LINENUMBER,L_COMMITDATE,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_COMMITDATE,L_TAX select L_LINENUMBER,L_COMMITDATE,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_COMMITDATE,L_TAX select L_TAX,L_LINENUMBER,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_LINENUMBER,L_COMMITDATE select L_TAX,L_COMMITDATE,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_COMMITDATE,L_LINENUMBER select L_TAX,L_COMMITDATE,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_COMMITDATE,L_LINENUMBER select L_TAX,L_COMMITDATE,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_COMMITDATE,L_LINENUMBER select L_COMMITDATE,L_LINENUMBER,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_LINENUMBER,L_TAX select L_COMMITDATE,L_TAX,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_TAX,L_LINENUMBER select L_COMMITDATE,L_TAX,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_TAX,L_LINENUMBER select L_COMMITDATE,L_TAX,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_TAX,L_LINENUMBER select C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY select C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY select C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT select C_NAME,C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_NATIONKEY select C_NAME,C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_MKTSEGMENT select C_NAME,C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_MKTSEGMENT select C_NATIONKEY,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_NAME select C_NATIONKEY,C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_MKTSEGMENT select C_MKTSEGMENT,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NAME select C_MKTSEGMENT,C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NATIONKEY select C_MKTSEGMENT,C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NATIONKEY select C_NAME,C_NATIONKEY,C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_NATIONKEY,C_MKTSEGMENT select C_NAME,C_MKTSEGMENT,C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_MKTSEGMENT,C_NATIONKEY select C_NATIONKEY,C_NAME,C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_NAME,C_MKTSEGMENT select C_NATIONKEY,C_NAME,C_MKTSEGMENT,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_NAME,C_MKTSEGMENT select C_NATIONKEY,C_MKTSEGMENT,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_MKTSEGMENT,C_NAME select C_MKTSEGMENT,C_NAME,C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NAME,C_NATIONKEY select C_MKTSEGMENT,C_NATIONKEY,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NATIONKEY,C_NAME select C_MKTSEGMENT,C_NATIONKEY,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NATIONKEY,C_NAME select S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL select S_ACCTBAL,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NAME select S_NAME,S_NATIONKEY,S_ACCTBAL,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_NATIONKEY,S_ACCTBAL select S_NATIONKEY,S_ACCTBAL,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=456) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_ACCTBAL,S_NAME select S_ACCTBAL,S_NATIONKEY,S_NAME,count(*) as cnt from ORDERS,CUSTOMER,SUPPLIER where O_CLERK in (select O_CLERK from ORDERS group by O_CLERK having count(*)=745) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NATIONKEY,S_NAME select L_LINENUMBER,count(*) as cnt from CUSTOMER,ORDERS,LINEITEM where C_ACCTBAL in (select C_ACCTBAL from CUSTOMER group by C_ACCTBAL having count(*)=15) and O_TOTALPRICE=L_EXTENDEDPRICE and O_CUSTKEY=C_CUSTKEY group by L_LINENUMBER select L_LINENUMBER,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_LINENUMBER select L_TAX,L_LINENUMBER,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_TAX,L_LINENUMBER select L_LINENUMBER,L_COMMITDATE,L_TAX,count(*) as cnt from PART,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and P_PARTKEY=PS_PARTKEY group by L_LINENUMBER,L_COMMITDATE,L_TAX select L_LINENUMBER,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_TAX select L_TAX,L_LINENUMBER,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_LINENUMBER select L_LINENUMBER,L_COMMITDATE,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_LINENUMBER,L_COMMITDATE,L_TAX select L_TAX,L_LINENUMBER,L_COMMITDATE,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=10) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_LINENUMBER,L_COMMITDATE select L_COMMITDATE,L_LINENUMBER,L_TAX,count(*) as cnt from SUPPLIER,PARTSUPP,LINEITEM where S_ACCTBAL in (select S_ACCTBAL from SUPPLIER group by S_ACCTBAL having count(*)=4) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_LINENUMBER,L_TAX select C_NATIONKEY,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_NAME select C_MKTSEGMENT,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NAME select C_NAME,C_MKTSEGMENT,C_NATIONKEY,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=643) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_MKTSEGMENT,C_NATIONKEY select C_NATIONKEY,C_MKTSEGMENT,C_NAME,count(*) as cnt from PARTSUPP,SUPPLIER,CUSTOMER where PS_AVAILQTY in (select PS_AVAILQTY from PARTSUPP group by PS_AVAILQTY having count(*)=800) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_MKTSEGMENT,C_NAME