Prudential Interview Question

Realize a SQL query using Pandas function