Answered step by step
Verified Expert Solution
Link Copied!

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 ai.the er diagram consists of invoice id, branch, city, customer type (member or normal), gender, product line, unit price, quantity, tax 5%, 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro SQL Server Administration

Authors: Peter Carter

1st Edition

1484207106, 9781484207109

More Books

Students also viewed these Databases questions

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago