Amazon|BIE|technical phone screen|SQL

ORDERS order_id varchar customer_id int order_datetime timestamp item_id varchar item_price decimal item_quantity int primary key (order_id, item_id) ITEMS item_id varchar(10) item_category varchar(20) primary key (item_id) ADDRESSES customer_id int start_date timestamp end_date timestamp zip_code...