need help with a query for a hospital database, that is giving me errors.

 

Create database HospitalDBCreate table Patients(PatientID int,PatientSSN varchar (9),PatientLName varchar (30),PatientFName varchar (20),PatientMName varchar (10),Gender varchar (1),DOB int,Patientht varchar (3),PatientWt int,PhoneHM varchar (10),PhoneCell varchar (10),PhoneWk varchar (10),PatientAddr varchar (20),PatientCity varchar (15),PatientState varchar (2),PatientZip int,PatientCounty varchar (15),PatientEmail varchar (20))Insert into Patients(PatientID, PatientSSN, PatientLName, PatientFName, PatientMName, Gender, DOB,Patientht, Patientwt, phoneHM, PHoneCell, PhoneWk, PatientAddr, PatientCity,PatientState, PatientZip, PatientCounty, PatientEmail)Values('100002','552137458','Hernandez','Noe','B','M','19950922','67','190','7142937815','','','123 Pear Ridge Dr','CostaMesa','CA','92626','Orange','yallcrazy@msn.com'),('100003','715223848','Lezama','Gustavo','C','M','19900621','61','150','3105271919','','','3055 Main St','SantaAna','CA','92707','Orange','Mznunu@hotmail.com'),('100005','835351897','Pantoja','Jose','E','M','19990819','70','250','6573371981','','','2301 Bristol St','SantaAna','CA','92706','Orange','JosePanto@yahoo.com'),('100004','988135725','Bravo','Juan','D','M','19960615','63','175','8185279175','','','727 Minnie St','Santa Ana','CA','92701','Orange','JuanBravo@yahoo.com'),('100001','321523177','Reyes','Jose','A','M','19820228','65','175','9492372154','9494520781','7142234714','1301 Orange Ave','GardenGrove','CA','92632','Orange','Dezz@yahoo.com')Create Table PatientRecord(RecordID int,PatientID varchar (10),Reason varchar (35),Date datetime,EmployeeID varchar (10),Diagnosis varchar (35),Recommendation varchar (35))Create Table PatientInsurance(PatientID varchar (10),InsPolicyNum varchar (15),InsName varchar (20),InsAddr varchar (20),InsCity varchar (15),InsState varchar (2),InsZip int,

Attachments:

• 1496025658-QUIZ SQL HOSPITAL NOTES 2ND DRAFT.txt