Chime interview question

most difficult questions in the SQL round were about window functions