Swiggy interview question

About Normal SQL terms and later about Joins and windows function