"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(*)=1385) 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(*)=1410) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       "
"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(*)=1385) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           "
"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(*)=1410) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           "
"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(*)=1385) 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(*)=1410) 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(*)=1385) 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(*)=1385) 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(*)=1385) 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(*)=1410) 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(*)=1385) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "
"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(*)=1410) 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(*)=1385) 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(*)=1385) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NAME,S_NATIONKEY,S_ACCTBAL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "
"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(*)=1410) 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(*)=1385) 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(*)=1410) 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(*)=1385) 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(*)=1385) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_NATIONKEY,S_ACCTBAL,S_NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "
"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(*)=1410) 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(*)=1385) 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(*)=1410) 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(*)=1385) and S_ACCTBAL=C_ACCTBAL and O_CUSTKEY=C_CUSTKEY group by S_ACCTBAL,S_NATIONKEY,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(*)=1410) 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(*)=1410) 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(*)=1385) 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(*)=1410) 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(*)=1410) 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(*)=8) and O_TOTALPRICE=L_EXTENDEDPRICE and O_CUSTKEY=C_CUSTKEY group by L_LINENUMBER                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       "
"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(*)=9) 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(*)=8) and O_TOTALPRICE=L_EXTENDEDPRICE and O_CUSTKEY=C_CUSTKEY group by L_TAX                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "
"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,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_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_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_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_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(*)=1) 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(*)=1) 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(*)=1) 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(*)=1) and 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(*)=3) 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(*)=1) 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 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(*)=1) 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(*)=3) 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(*)=1) 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(*)=1) 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(*)=3) 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(*)=3) 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(*)=1) 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(*)=3) 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 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(*)=1) 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(*)=3) 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(*)=1) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_TAX,L_LINENUMBER,L_COMMITDATE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "
"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(*)=3) 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(*)=1) 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(*)=3) 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(*)=1) and PS_SUPPLYCOST=L_EXTENDEDPRICE and PS_SUPPKEY=S_SUPPKEY group by L_COMMITDATE,L_LINENUMBER,L_TAX                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             "
"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(*)=3) 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(*)=1) 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(*)=3) 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(*)=720) 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(*)=816) 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(*)=720) 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(*)=720) 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(*)=720) 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(*)=816) 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(*)=720) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         "
"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(*)=816) 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(*)=720) 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(*)=720) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,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(*)=816) 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(*)=720) 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(*)=816) 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(*)=720) 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(*)=720) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NAME,C_MKTSEGMENT,C_NATIONKEY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               "
"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(*)=816) 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(*)=720) 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(*)=816) 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(*)=720) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_NATIONKEY,C_MKTSEGMENT,C_NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               "
"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(*)=816) 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(*)=816) 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(*)=720) 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(*)=816) and S_ACCTBAL=C_ACCTBAL and PS_SUPPKEY=S_SUPPKEY group by C_MKTSEGMENT,C_NATIONKEY,C_NAME                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               "