Optum interview question

join query in sql and same in python pandas