Amazon interview question

Questions related to advance PLSQL