use scratch
go

if object_id('customer') is not null
	drop table customer
go

create table customer (
	customer_id int identity not null primary key clustered,
	first_name varchar(30) not null,
	last_name varchar(40) not null,
	birthday datetime not null
)
go

insert into customer(first_name, last_name, birthday) values ('Chris', 'Carter', '6/18/1970')
insert into customer(first_name, last_name, birthday) values ('Anja', 'Carter', '3/30/1971')
insert into customer(first_name, last_name, birthday) values ('Riley', 'Carter', '4/11/2004')
insert into customer(first_name, last_name, birthday) values ('Emmitt', 'Carter', '10/14/2006')
go