How do I write an SQL Query containing: 1. Data capable of identifying the patie

Question

How do I write an SQL Query containing:
1. Data capable of identifying the patient’s insurance company name
2. Data capable of describing the patient’s 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

Explanation / Answer

1.

Select ProviderName from InsuranceProvider inner join PatientVisits on InsuranceProvider.ProviderID = PatientVisits.InsuranceProviderID;

2.

Select PatientCity,PatientState,PatientZip from PatientVisits;

3.

Select sum(cost) from Drugs inner join Drug_Administration on Drug.DrugID = Drug_Administration.DrugID inner join Cases on Cases.CaseID = Drug_Administration.CaseID;

Do ask if any query . Please upvote if it is helpful.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.