Swiggy Interview Question

Question based on join ,aggregate function