Database-Focused Technical Questions | Dataford Interview Questions

Explain how you would answer technical questions mostly around databases.

Use the supplied question and answer records to demonstrate your database-focused SQL reasoning. Return one summary row for each database topic, including topics without a qualifying answer.

Output

Columns: topic, answer_count, average_score, and assessment
Include only database topics and answers submitted during the first quarter of 2026
Count all qualifying answers, average non-null scores, and classify results as No answers, No scored answers, Strong, or Needs review
Order by average score descending with null averages last, then topic ascending

Schema

technical_questions

Column	Type	Description
question_idPK	INT	Unique technical question identifier
topic	VARCHAR(100)	Database or other technical topic
prompt	TEXT	Question text
is_database_topic	BOOLEAN	Whether the question belongs to the database topic set

candidate_answers

Column	Type	Description
answer_idPK	INT	Unique answer identifier
question_id	INT	Referenced technical question
submitted_at	TIMESTAMP	Answer submission timestamp
score	INT	Evaluation score from 1 through 5
feedback	TEXT	Evaluator feedback

Your question is Database-Focused Technical Questions. 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