vmart_query_02.sql
-- vmart_query_02.sql -- WHERE clause subquery -- Asks for all orders placed by stores located in Massachusetts -- and by vendors located elsewhere before March 1, 2003:
SELECT order_number, date_ordered FROM store.store_orders_fact orders WHERE orders.store_key IN ( SELECT store_key FROM store.store_dimension WHERE store_state = 'MA') AND orders.vendor_key NOT IN ( SELECT vendor_key FROM public.vendor_dimension WHERE vendor_state = 'MA') AND date_ordered < '2012-03-01';
Output
order_number | date_ordered -------------+-------------- 53019 | 2012-02-10 222168 | 2012-02-05 160801 | 2012-01-08 106922 | 2012-02-07 246465 | 2012-02-10 234218 | 2012-02-03 263119 | 2012-01-04 73015 | 2012-01-01 233618 | 2012-02-10 85784 | 2012-02-07 146607 | 2012-02-07 296193 | 2012-02-05 55052 | 2012-01-05 144574 | 2012-01-05 117412 | 2012-02-08 276288 | 2012-02-08 185103 | 2012-01-03 282274 | 2012-01-01 245300 | 2012-02-06 143526 | 2012-01-04 59564 | 2012-02-06 ...