Walk me through how you would prepare for a take-home SQL round and an in-person SQL round using your previous projects.
Use the project history below to identify which projects are strongest for each round and summarize the SQL themes they demonstrate.
project_name, best_round, sql_focus, why_it_helpsbest_round, then project_name| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique project identifier |
| project_name | VARCHAR(255) | Project title |
| take_home_strength | INT | Relative strength for take-home rounds |
| in_person_strength | INT | Relative strength for in-person rounds |
| is_relevant | BOOLEAN | Whether the project should be used for interview prep |
| Column | Type | Description |
|---|---|---|
| project_id | INT | References projects.project_id |
| topic_id | INT | References topics.topic_id |
| Column | Type | Description |
|---|---|---|
| topic_idPK | INT | Unique topic identifier |
| topic_name | VARCHAR(100) | SQL theme name |