Average Score SQL Query | Dataford Interview Questions

How would you compute the average score by question using SQL?

Use the questions and responses tables. Include every question, ignore NULL scores when calculating averages, and preserve questions with no scored responses.

Output

One row per question with question_id, question_text, and average_score
Return NULL for questions without scored responses
Order by question_id ascending

Schema

questions

Column	Type	Description
question_idPK	INT	Unique identifier for the question
question_text	VARCHAR(255)	Text displayed for the question

responses

Column	Type	Description
response_idPK	INT	Unique identifier for the response
question_id	INT	Question answered by the response
respondent_name	VARCHAR(100)	Optional respondent name
score	NUMERIC(4,2)	Numeric score assigned to the response

Your question is Average Score SQL Query. Start with the requirements and the two tables 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.

Problem