How do I write one SQL Query combining the three below into one table?

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 (computed by QuantityGiven * Cost)

HOSPITALEMRDATA.DBO dbo.InsuranceProviders ProviderName City State Zip

dbo.Patients PatientID PatientName Birthdate MRN

dbo.PatientVisits PatientVisitID PatientID AdmissionDate DischargeDate InsuranceProviderID PatientCity PatientState PatientZip

SURGERYDATA.DBO dbo.Drug_Administrations DrugAdministraionID CaseID DrugID TimeGiven QuantityGiven

dbo.Cases CaseID MRN SurgeryData SurgeryStart SurgeryFinish ServiceLineID

dbo.Drugs DrugID Name Cost

dbo.ServiceLine ServiceLineID ServiceLineName