• Home
• com.facebook.presto
• presto-product-tests
• 0.198
• source code
• q41.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql-tests.testcases.tpcds.q41.sql Maven / Gradle / Ivy

-- database: presto_tpcds; groups: tpcds; requires: io.prestodb.tempto.fulfillment.table.hive.tpcds.ImmutableTpcdsTablesRequirements
SELECT DISTINCT "i_product_name"
FROM
  item i1
WHERE ("i_manufact_id" BETWEEN 738 AND (738 + 40))
   AND ((
      SELECT "count"(*) "item_cnt"
      FROM
        item
      WHERE (("i_manufact" = "i1"."i_manufact")
            AND ((("i_category" = 'Women                                             ')
                  AND (("i_color" = 'powder              ')
                     OR ("i_color" = 'khaki               '))
                  AND (("i_units" = 'Ounce     ')
                     OR ("i_units" = 'Oz        '))
                  AND (("i_size" = 'medium              ')
                     OR ("i_size" = 'extra large         ')))
               OR (("i_category" = 'Women                                             ')
                  AND (("i_color" = 'brown               ')
                     OR ("i_color" = 'honeydew            '))
                  AND (("i_units" = 'Bunch     ')
                     OR ("i_units" = 'Ton       '))
                  AND (("i_size" = 'N/A                 ')
                     OR ("i_size" = 'small               ')))
               OR (("i_category" = 'Men                                               ')
                  AND (("i_color" = 'floral              ')
                     OR ("i_color" = 'deep                '))
                  AND (("i_units" = 'N/A       ')
                     OR ("i_units" = 'Dozen     '))
                  AND (("i_size" = 'petite              ')
                     OR ("i_size" = 'large               ')))
               OR (("i_category" = 'Men                                               ')
                  AND (("i_color" = 'light               ')
                     OR ("i_color" = 'cornflower          '))
                  AND (("i_units" = 'Box       ')
                     OR ("i_units" = 'Pound     '))
                  AND (("i_size" = 'medium              ')
                     OR ("i_size" = 'extra large         ')))))
         OR (("i_manufact" = "i1"."i_manufact")
            AND ((("i_category" = 'Women                                             ')
                  AND (("i_color" = 'midnight            ')
                     OR ("i_color" = 'snow                '))
                  AND (("i_units" = 'Pallet    ')
                     OR ("i_units" = 'Gross     '))
                  AND (("i_size" = 'medium              ')
                     OR ("i_size" = 'extra large         ')))
               OR (("i_category" = 'Women                                             ')
                  AND (("i_color" = 'cyan                ')
                     OR ("i_color" = 'papaya              '))
                  AND (("i_units" = 'Cup       ')
                     OR ("i_units" = 'Dram      '))
                  AND (("i_size" = 'N/A                 ')
                     OR ("i_size" = 'small               ')))
               OR (("i_category" = 'Men                                               ')
                  AND (("i_color" = 'orange              ')
                     OR ("i_color" = 'frosted             '))
                  AND (("i_units" = 'Each      ')
                     OR ("i_units" = 'Tbl       '))
                  AND (("i_size" = 'petite              ')
                     OR ("i_size" = 'large               ')))
               OR (("i_category" = 'Men                                               ')
                  AND (("i_color" = 'forest              ')
                     OR ("i_color" = 'ghost               '))
                  AND (("i_units" = 'Lb        ')
                     OR ("i_units" = 'Bundle    '))
                  AND (("i_size" = 'medium              ')
                     OR ("i_size" = 'extra large         ')))))
   ) > 0)
ORDER BY "i_product_name" ASC
LIMIT 100