text: -- http://www.sqlserver-dba.com/2011/09/this-is-a-followup-on-my-earlier-post-of-sql-server-test-data-generation-testing-tools-i-had-some-requests-for-my-set-up-pr.html
  -- TPC_H Query 16 - Parts/Supplier Relationship
  SELECT P_BRAND, P_TYPE, P_SIZE, COUNT(DISTINCT PS_SUPPKEY) AS SUPPLIER_CNT
  FROM PARTSUPP, "PART"
  WHERE P_PARTKEY = PS_PARTKEY AND P_BRAND <> 'Brand#45' AND P_TYPE NOT LIKE 'MEDIUM POLISHED%%'
  AND P_SIZE IN (49, 14, 23, 45, 19, 3, 36, 9) AND PS_SUPPKEY NOT IN (SELECT S_SUPPKEY FROM SUPPLIER
   WHERE S_COMMENT LIKE '%%Customer%%Complaints%%')
  GROUP BY P_BRAND, P_TYPE, P_SIZE
  ORDER BY SUPPLIER_CNT DESC, P_BRAND, P_TYPE, P_SIZE;