SQL Average Visits by Region | Dataford Interview Questions

Write a SQL query using GROUP BY and aggregate functions to calculate the average number of patient visits per clinician region.

Use the clinician_visit_summary table. Include every region, including a NULL region when present, and ignore NULL visit counts in the average.

Output

clinician_visit_summary

Column	Type	Description
clinician_idPK	VARCHAR(20)	Unique clinician identifier
clinician_region	VARCHAR(50)	Region assigned to the clinician
patient_visit_count	INT	Number of patient visits attributed to the clinician

Your question is SQL Average Visits by Region. 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 using GROUP BY and aggregate functions to calculate the average number of patient visits per clinician region.

Use the clinician_visit_summary table. Include every region, including a NULL region when present, and ignore NULL visit counts in the average.

clinician_visit_summary

Column	Type	Description
clinician_idPK	VARCHAR(20)	Unique clinician identifier
clinician_region	VARCHAR(50)	Region assigned to the clinician
patient_visit_count	INT	Number of patient visits attributed to the clinician

Your question is SQL Average Visits by Region. 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.