People10 interview question

SQL queries, normalisation, python code