REVOLVE interview question

SQL questions: some similar functions differences