Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started