How do I write an SQL Query containing: 1. Data capable of identifying the patients insurance company name 2. Data capable of describing the patients geographic location 3. An aggregation column showing the total cost of drugs administered during surgery

HOSPITALEMRDATA dbo.InsuranceProvider ProviderName City State Zip

dbo.Patiens PatientID PatientName Birthdate MRN

dbo.PatientVisits PatientVisitID PatientID AdmissionDate DischargeDate InsuranceProviderID PatientCity PatientState PatientZip

SURGERYDATA.DBO dbo.Drug_Administration DrugAdministraionID CaseID DrugID TimeGiven QuantityGiven

dbo.Cases CaseID MRN SurgeryData SurgeryStart SurgeryFinish ServiceLineID

dbo.Drugs DrugID Name Cost

dbo.ServiceLine ServiceLineID ServiceLineName