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

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

Output details

• Count distinct concept_name values for each round’s SQL assignments.
• Round avg_sql_depth to two decimal places.
• Retain every interview-round row, including rows sharing the same round_number.