CDO FoodSphere interview question

SQL query for row_number and dense rank