Amazon interview question

Questions on SQL - something which required me to write syntax using self join clause.