The provided data set named “supermarket_transactions.csv” contains three years of transactional data collected from supermarkets across Australia.

InsightSpark wants to access the data to perform some analysis across Australian supermarkets. Before this can happen, I need to perform some analysis on the provided CSV data set (a sample of the database) to answer the following questions:

Across locations, how many apples were purchased in cash? How much total cash was spent on these apples? Across all payment methods, how much money was spent at the Bakershire store location by non-member customers?