Question: help me brainstorm some questions for my SQL project on supermarket data. my sql project objective is To leverage SQL driven data analysis for maximize
help me brainstorm some questions for my SQL project on supermarket data. my sql project objective is To leverage SQL driven data analysis for maximize sales by analyzing sales data, optimizing products, and understanding customer behavior. so far these questions i have came up with on my own due to the easyness of writing the query but i need one more question please help me come up with it please try not to use chatgpt or aithe er diagram consists of invoice id branch, city, customer type member or normal gender, product line, unit price, quantity, tax total, date, time, payment cogs, gross margin percentage, gross income, and rating. here are the questions ive come up with: What are top selling products by category?
What is the average purchase value per customer type?
What are the top selling products by Members?
What is the average customer rating by branch and membership status?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
