Time spent on the Python tasks: 2-3hrs
The easiest way to test the code would be to copy the tasks.py and paste into an online compiler like this one: Python Online Compiler
Alternatively run it in a terminal following the steps below:
git clone [email protected]:code-karma/artlogic-python.gitcd artlogic-pythonpython tasks.py
It is worth mentioning that the solution would be much more elegant in OOP Python with access to the MySql DB and a data framework. It would require a couple of lines of code. Also, if I used PHP this would take no more than 1 hour to complete but I learnt a bit more about Python and I am quite sure I could master it within weeks.