Amazon interview question

SQL questions like joins, window functions were asked