Conduent Interview Question

SQL query in a real time example where we need to use self join