SQL for Average Medication Cost | Dataford Interview Questions

Write a SQL query to find the average medication cost for patients over 65.

Use the medication_costs table and exclude patients whose age is 65 or younger.

Output

Return one row with the column average_medication_cost.
The value should be the average of available medication costs for qualifying patients, rounded to two decimal places.

medication_costs

Column	Type	Description
patient_idPK	INT	Unique patient identifier
patient_age	INT	Patient age in years
medication_cost	NUMERIC(10,2)	Recorded medication cost for the patient

Your question is SQL for Average Medication Cost. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Write a SQL query to find the average medication cost for patients over 65.

Use the medication_costs table and exclude patients whose age is 65 or younger.

Return one row with the column average_medication_cost.
The value should be the average of available medication costs for qualifying patients, rounded to two decimal places.

medication_costs

Column	Type	Description
patient_idPK	INT	Unique patient identifier
patient_age	INT	Patient age in years
medication_cost	NUMERIC(10,2)	Recorded medication cost for the patient

Your question is SQL for Average Medication Cost. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.