The sales table contains the store ID, order numbers, and dates of sales.
sales is defined as:
create table sales (stor_id char(4) not null references stores(stor_id), ord_num numeric(6,0) identity, date datetime not null, unique nonclustered (ord_num))