Conduent interview question

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