use test; create table sales ( seller char(50), location char(50), buyer char(50), price integer, closing_date date );