vmart_query_05.sql
-- vmart_query_05.sql -- EXISTS predicate -- Get a list of all the orders placed by all stores on -- January 2, 2003 for the vendors with records in the -- vendor_dimension table
SELECT store_key, order_number, date_ordered FROM store.store_orders_fact WHERE EXISTS ( SELECT 1 FROM public.vendor_dimension WHERE public.vendor_dimension.vendor_key = store.store_orders_fact.vendor_key) AND date_ordered = '2012-01-02';
Output
store_key | order_number | date_ordered -----------+--------------+-------------- 98 | 151837 | 2012-01-02 123 | 238372 | 2012-01-02 242 | 263973 | 2012-01-02 150 | 226047 | 2012-01-02 247 | 232273 | 2012-01-02 203 | 171649 | 2012-01-02 129 | 98723 | 2012-01-02 80 | 265660 | 2012-01-02 231 | 271085 | 2012-01-02 149 | 12169 | 2012-01-02 141 | 201153 | 2012-01-02 1 | 23715 | 2012-01-02 156 | 98182 | 2012-01-02 44 | 229465 | 2012-01-02 178 | 141869 | 2012-01-02 134 | 44410 | 2012-01-02 141 | 129839 | 2012-01-02 205 | 54138 | 2012-01-02 113 | 63358 | 2012-01-02 99 | 50142 | 2012-01-02 44 | 131255 | 2012-01-02
...