DoorDash interview question

Walk me through this sql query