Rheal Software interview question

self join- manager and employee query