Swiggy Interview Question

About Normal SQL terms and later about Joins and windows function