Safaricom interview question

SQL Joins, SQL optimization Implementing something in Python/Java