SQL Round and Case Studies | Dataford Interview Questions

Tell me about a time you handled an interview-style SQL coding round and case studies based on your resume, including past experience.

For this hands-on SQL interpretation, summarize completed interview rounds and their associated case studies from the provided records. Include interview rounds without case studies and exclude cancelled rounds.

Output

One row per completed interview round, with round_id, candidate_name, round_date, sql_score, case_study_count, and case_study_status
Include rounds with zero case studies, classify them as No Case Study, and classify others as Has Case Study
Order by round_date descending, then round_id ascending

Schema

interview_rounds

Column	Type	Description
round_idPK	INT	Unique interview round identifier
candidate_name	VARCHAR(100)	Candidate name
round_date	DATE	Date of the interview round
sql_score	DECIMAL(5,2)	SQL assessment score
round_status	VARCHAR(20)	Interview round status

case_studies

Column	Type	Description
case_study_idPK	INT	Unique case study identifier
round_id	INT	Interview round associated with the case study
case_title	VARCHAR(150)	Case study title
case_status	VARCHAR(20)	Case study status

Your question is SQL Round and Case Studies. 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