ION Group Interview Question

SQL question on a given case scenario of supermarkets