Persistent Systems Interview Question

simple join SQL query