CompassX Consulting interview question

Technical SQL and Python Situation type question