vmart_query_06.sql
-- vmart_query_06.sql -- EXISTS predicate -- Orders placed by the vendor who got the best deal -- on January 4, 2004
SELECT store_key, order_number, date_ordered FROM store.store_orders_fact ord, public.vendor_dimension vd WHERE ord.vendor_key = vd.vendor_key AND vd.deal_size IN ( SELECT MAX(deal_size) FROM public.vendor_dimension) AND date_ordered = '2013-01-04';
Output
store_key | order_number | date_ordered -----------+--------------+-------------- 45 | 202416 | 2013-01-04 24 | 250295 | 2013-01-04 121 | 251417 | 2013-01-04 198 | 75716 | 2013-01-04 166 | 36008 | 2013-01-04 27 | 150241 | 2013-01-04 148 | 182207 | 2013-01-04 9 | 188567 | 2013-01-04 113 | 66017 | 2013-01-04 ...