Give me a list of distinct product ids from orders placed between 1975-01-01 and 1976-01-01?
create table order_items (product_id varchar, order_id varchar, PRIMARY KEY (product_id)); create table orders (order_id varchar, date_order_placed varchar, PRIMARY KEY (order_id))
select distinct t2.product_id from orders as t1 join order_items as t2 on t1.order_id = t2.order_id where t1.date_order_placed >= "1975-01-01" and t1.date_order_placed <= "1976-01-01"