use cs304_db;

drop table if exists car_sales;
create table car_sales(
       sid int auto_increment,
       dealership varchar(30),
       region enum('north','south'),
       model enum('Prius','Corolla'),
       price int,
       primary key(sid)
);