drop table STUDENT;
create table STUDENT (ID int , FIRSTNAME varchar(20),LASTNAME varchar(20), GENDER varchar(6));
insert into STUDENT values (1001, "Josh", "Smith", "Male");
insert into STUDENT values (1002, "Anne","Brown", "Female");
select * from STUDENT;










create table EVALUATION (COURSE varchar(20),GENDER varchar(20), GRADE varchar(20) ,QUESTION1 int , QUESTION2 int, QUESTION3 int);
insert into  EVALUATION values ("CS212","Female","Freshman",2,2,2);
insert into  EVALUATION values ("CS110","Male","Freshman",1,2,1);
insert into  EVALUATION values ("CS310","Female","Junior",0,1,0);
select* from EVALUATION;



















drop table PLACES;

create table PLACES (PLACE varchar(100),CITY varchar(100), ADDRESS varchar(100),ZIP int,HOURS varchar(100),MORE_INFO varchar(100));

insert into  PLACES values ("Botanical Garden","Norfolk","6700 Azalea Garden Rd.",23518,"9am-7pm","Fill");
insert into  PLACES values ("Virginia Zoological Park","Norfolk","3500 Granby st.",23504,"10am-5pm","Fill");

insert into  PLACES values ("Children's Museum of Virgina","Porthmouth","221 High st.",23704,"9am-5pm","Fill");
insert into  PLACES values ("Olde Towne Arts and Music","Porthmouth","606 Court st.",23704,"10am-7pm","Fill");

insert into  PLACES values ("Virgina Aquarium and Marine Science Center","Virginia Beach","717 General Booth Blvd.",23451,"9am-5pm","Fill");
insert into  PLACES values ("Military Aviation Museum","Virgina Beach","1341 Princess Anne Rd.",23457,"9am-5pm","Fill");
insert into  PLACES values ("First Landing State Park","Virgina Beach","2500 Shore Dr.",23451,"8am-6pm","Fill");
insert into  PLACES values ("Ocean Breeze Waterpark","Viginia Beach","849 General Booth Blvd.",23451,"9am-5pm","Fill");

insert into  PLACES values ("Great Dismal Swamp National Wildlife Refuge","Suffolk","3120 Desert Rd.",23518,"8am-4pm","Fill");

insert into  PLACES values ("Busch Gardens ","Williamsburg","1 Busch Gardens Blvd",23185,"10am-5pm","Fill");
insert into  PLACES values ("Muscarelle Museum of Art","Williamsburg","603 Jamestown Rd",23185,"10am-5pm","Fill");
insert into  PLACES values ("Williamsburg Winery","Williamsburg","5800 Wessex Hundred",23518,"11am-5:30pm","Fill");

insert into  PLACES values ("Virginia Museum of Fine Arts","Richmond","200 N Arthur Ashe Blvd", 23220,"10am-9pm","Fill");
insert into  PLACES values ("The Edgar Allan Poe Museum","Richmond","1914 E Main St", 23223,"10am-5pm","Fill");


select * from PLACES;



drop table REST;

create table REST (RESTAURANTS varchar(100),FOOD_TYPE varchar(100),CITY varchar(100), ADDRESS varchar(100),ZIP int,HOURS varchar(100),MORE_INFO varchar(100));

insert into  REST values ("Freemason Abbey Restaurant ","American","Norfolk","209 W Freemason st.",23510,"11am-9:30pm","Fill");
insert into  REST values ("LeGrand Kitchen","American","Norfolk","4515 Colley Ave", 23508,"5pm-9pm","Fill");
insert into  REST values ("Saltine","Seafood","Norfolk","100 E Main St." ,23510,"11:30m-10pm","Fill"); 
 
insert into  REST values ("Tupelo Honey ","Southern","Virginia Beach","4501 Main St.", 23462,"10:30am-9pm","Fill"); 
insert into  REST values ("Mannino's Italian Bistro","Italian","Virginia Beach","4402 Princess Anne Rd",23462,"5pm-10pm","Fill");
insert into  REST values ("Repeal Bourbon & Burgers","American","Virginia Beach","202 22nd St.", 23451,"11am-11pm","Fill");

insert into  REST values ("Waypoint Seafood & Grill","Seafood","Williamsburg","480 Quarterpath Rd",23185 ,"11am-9pm","Fill");
insert into  REST values ("Le Yaca French Restaurant","French","Williamsburg","1430 High St.",23188,"11:30am-10pm","Fill");  
insert into  REST values ("Antonio's Ristorante Italiano","Italian","Williamsburg","801 Merrimac Trail E.",23185,"11am-10pm","Fill");  

insert into  REST values ("Stella's","Greek","Richmond","1012 Lafayette St.", 23221 ,"11am-10pm","Fill");      
insert into  REST values ("Heritage Restaurant","American","Richmond","1627 W Main St",23220,"5pm-10pm","Fill");    




select * from REST;






drop table NEWS;

create table NEWS (FULL_NAME varchar(100),EMAIL varchar(100));

insert into  NEWS values ("John Smith ","Jsmith@gmail.com");
select * from NEWS;