week4day2.sql

create table Cities
(
 ID int identity (1,1),
 PlaceName varchar(50) not null,
 Estimate2013 int not null,
 Census2010 int not null,
 Change decimal (10,2) not null
 );



 insert into [Cities]
 (PlaceName, Estimate2013, Census2010, Change)
 values ('Houston', 2195914,2100263,4.55)
 insert into [Cities]
 (PlaceName, Estimate2013, Census2010, Change)
  values ('San Antonio',1409019, 1327407,6.15)
  insert into [Cities]
 (PlaceName, Estimate2013, Census2010, Change)
 values ('Dallas',1257676,1197816,5.00)
 insert into [Cities]
 (PlaceName, Estimate2013, Census2010, Change)
 values ('Austin',885400,790390,12.02)
 insert into [Cities]
 (PlaceName, Estimate2013, Census2010, Change)
 values ('Fort Worth',792727,741206,6.95);
 
 select * from Cities;
 
 
 

 delete from Cities where PlaceName= 'Dallas';