Data Engineering Concepts and In-Depth SQL/Python

Tell me about the data engineering concepts, Python, and SQL you would go deep on across multiple rounds of interviews.

For the SQL portion, use the supplied interview-round and topic-assignment tables to summarize SQL coverage across all rounds.

Output

One row per interview round, including rounds without SQL assignments.
Columns: round_number, round_name, sql_concept_count, and avg_sql_depth.
Sort by round_number ascending. Use zero for rounds without SQL concepts and NULL for their average depth.

interview_rounds

Column	Type	Description
round_idPK	INT	Unique identifier for an interview round
round_number	INT	Sequential interview round number
round_name	VARCHAR(100)	Name of the interview round

topic_assignments

Column	Type	Description
assignment_idPK	INT	Unique topic assignment identifier
round_id	INT	Interview round associated with the assignment
topic_area	VARCHAR(50)	High-level topic area
concept_name	VARCHAR(100)	Specific concept assigned to the round
planned_depth	INT	Planned depth rating for the concept

Your question is Data Engineering Concepts and In-Depth SQL/Python. 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.