SQL and Conceptual Fundamentals | Dataford Interview Questions

Tell me about your approach to answering medium-level SQL questions and related data concepts.

Use the supplied relational data to demonstrate that approach by summarizing medium-difficulty questions by topic. Include topics with no recorded attempts and calculate metrics only from available scores.

Output

One row per medium-difficulty topic, with topic, question_count, attempted_count, average_score, and pass_rate.
Include topics without attempts, using NULL for unavailable score metrics.
Sort alphabetically by topic.

Schema

sql_questions

Column	Type	Description
question_idPK	INT	Unique question identifier
topic	VARCHAR(100)	SQL or data concept tested
difficulty	VARCHAR(20)	Question difficulty level

question_attempts

Column	Type	Description
attempt_idPK	INT	Unique attempt identifier
question_id	INT	Question being attempted
score	INT	Attempt score from 0 to 100

Your question is SQL and Conceptual Fundamentals. 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