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(1000),CITY varchar(1000), ADDRESS varchar(1000),ZIP int,MORE_INFO varchar(1000));

insert into  PLACES values ("Liberating Lives Christian Counseling & Psychological Services","Norfolk","6325 N Center Dr #208",23502,"<A HREF=https:http://www.liberatinglives.org/ target=_blank> Click Here </A>");
insert into  PLACES values ("Family Insight, PC","Norfolk","13, 6330 N Center Dr #200",23502,"<A HREF=https://familyinsight.net/location/virginia-beach-va/ target=_blank  > Click Here </A>");
insert into  PLACES values ("McNeill Therapy & Testing Services","Norfolk","6330 Newtown Rd #525",23502,"<A HREF= https://www.goodtherapy.org/therapists/profile/jeninne-mcneill-20160828  target=_blank> Click Here </A>");
insert into  PLACES values ("Relationship Counseling for Individuals Couples and Families in Norfolk","Norfolk","129 W Virginia Beach Blvd #204a",23510,"<A HREF=https://deepconnectionscounseling.com/ target=_blank > Click Here </A>");


insert into  PLACES values ("Sunrise Counseling and Psychological Services","Virginia Beach","780 Lynnhaven Pkwy #340",23452,"<A HREF=https://www.vbmentalhealth.com/ target=_blank> Click Here </A>");
insert into  PLACES values ("Thriveworks Counseling","Virginia Beach","516 S Independence Blvd #104",23452,"<A HREF=https://thriveworks.com/virginia-beach-counseling/https://thriveworks.com/virginia-beach-counseling/ target=_blank> Click Here</A>");

insert into  PLACES values ("Meridian Psychotherapy","Virginia Beach","4509 Whitechapel Dr.",23455,
"<A HREF=https://meridianpsych.net/ target=_blank> Click Here</A>");

insert into  PLACES values ("Susan E Masterson LCSW - Masterson Psychotherapy","Virginia Beach","4445 Corporation Ln",23462,
"<A HREF=https://www.mastersonpsychotherapy.com/ target=_blank> Click Here</A>");


insert into  PLACES values ("Paramount Counseling Inc.","Newport News","105 Nat Turner Blvd",23606,
"<A HREF=https://paramount-counseling-inc.business.site/ target=_blank> Click Here</A>");



insert into  PLACES values ("Thriveworks Counseling","Newport News","8 San Jose Dr #3e",23606,
"<A HREF=https://thriveworks.com/newport-news-counseling/ target=_blank> Click Here</A>");

insert into  PLACES values ("TPMG Behavioral Health","Newport News","11818 Rock Landing Dr Suite 101",23606,
"<A HREF=https://mytpmg.com/location/psychiatry-and-behavioral-health-2/?utm_source=GMBlisting&utm_medium=organic target=_blank> Click Here</A>");


insert into  PLACES values ("Harry W. Cole Jr, PhD","Newport News","802 Suite B Lockwood Ave",23602,
"<A HREF=https://www.vitals.com/doctors/Dr_Harry_W_Cole.html  target=_blank> Click Here</A>");


insert into  PLACES values ("Thriveworks Counseling","Chesapeake","3804 Poplar Hill Rd suite d",23321,
"<A HREF=https://thriveworks.com/chesapeake-counseling/  target=_blank> Click Here</A>");

insert into  PLACES values ("Cognitive Behavior Therapy Center","Chesapeake","1403 Greenbrier Pkwy #215",23320,
"<A HREF=https://cbtcenter.biz/  target=_blank> Click Here</A>");

insert into  PLACES values ("Empowerment Counseling Center","Chesapeake","1015 Eden Way N suite b",23320,
"<A HREF=http://empowermentcounselingctr.com/ target=_blank> Click Here</A>");


insert into  PLACES values ("Bonheur & Associates Counseling Center","Portsmouth","5939 Village St",23703,
"<A HREF=https://www.bonheurassociatescounselingcenterltd.com/ target=_blank> Click Here</A>");

insert into  PLACES values ("Renewed Perspectives Counseling and Consulting LLC","Portsmouth","3300 Tyre Neck Rd suite a",23703,
"<A HREF=https://www.renewedperspectives.info/ target=_blank> Click Here</A>");




select * from PLACES;


create table UPDATE ( NAME varchar(100),EMAIL varchar(100));
select * from UPDATE;



create table TIPS ( NAME varchar(100),ANXIETY_TIPS varchar(3000));
select * from TIPS;

drop table THERAPY;
create table THERAPY ( TYPE varchar(100), CHOICE_1 varchar(100),CHOICE_2 varchar(100));
insert into THERAPY values ("GAD","Cognative Behavioral Therapy", "None");
insert into THERAPY values ("SAD"," CBT Based-Exposure Therapy", "None");
insert into THERAPY values ("PD","Cognative Behavioral Therapy", " Panic-Focused Psychodynamic Therapy");
insert into THERAPY values ("OCD","Exposure and Response Prevention Therapy", "Cognative Behavioral Therapy");
insert into THERAPY values ("PTSD"," CBT Based-Exposure Therapy", "Eye Movement Desensitization and Reprocessing Therapy");
select * from THERAPY;




drop table USERNEWSLETTER;
create table USERNEWSLETTER (DATE varchar(100),FULL_NAME varchar(100),EMAIL varchar(100),COMMENTS varchar(1000));
select * from USERNEWSLETTER;
























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;