Task: Text to Code
Input (English): find without repetition the product_id of Order_Items table for which order_id equals or between 1975-01-01 and 1976-01-01
Output (English): SELECT DISTINCT product_id FROM Order_Items WHERE order_id BETWEEN "1976-01-01" AND "1975-01-01"