The sales table contains the store id, order number, and date of sales in the pubs3 database.
sales is defined as follows:
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))
