SQL: Average Rating by Therapist | Dataford Interview Questions

Write a SQL query to find the average user rating for each therapist.

Use the therapist_ratings table. Include therapists whose records contain only missing ratings, and do not treat missing ratings as zero.

Output

One row per therapist, with therapist_id, therapist_name, and average_rating
Include all therapists in the table
Sort by therapist_id in ascending order

therapist_ratings

Column	Type	Description
rating_idPK	INT	Unique identifier for a rating record
therapist_id	INT	Identifier of the therapist being rated
therapist_name	VARCHAR(100)	Display name of the therapist
user_rating	INT	Rating submitted by a user, from 1 to 5

Your question is SQL: Average Rating by Therapist. 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 user rating for each therapist.

Use the therapist_ratings table. Include therapists whose records contain only missing ratings, and do not treat missing ratings as zero.

One row per therapist, with therapist_id, therapist_name, and average_rating
Include all therapists in the table
Sort by therapist_id in ascending order

therapist_ratings

Column	Type	Description
rating_idPK	INT	Unique identifier for a rating record
therapist_id	INT	Identifier of the therapist being rated
therapist_name	VARCHAR(100)	Display name of the therapist
user_rating	INT	Rating submitted by a user, from 1 to 5

Your question is SQL: Average Rating by Therapist. 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.