Tide interview question

SQL questions based on aggregate questions and window funcations