--Sql Server 2014 Express Edition
--Batches are separated by 'go'

create table customer
(
    customerid int primary key,
    first_name varchar(50),
    last_name varchar(50),
    zipcode int not null,
    city char(50) 
 )   
 
 select * from customer