Question
Table structure given below: product (prod-id,prod-name,maj-cat-cd,cat-cd,sub-cat-cd,segment-cd) store (str-nbr,str-name,st-cd,zip-3-cd) sale (bskt-nbr,str-nbr,prod-id,sls-dte-nbr,sls-dte-amt,sls-qty) Write MySQl statement for the following. Find the number of stores with sale more than
Table structure given below:
product (prod-id,prod-name,maj-cat-cd,cat-cd,sub-cat-cd,segment-cd)
store (str-nbr,str-name,st-cd,zip-3-cd)
sale (bskt-nbr,str-nbr,prod-id,sls-dte-nbr,sls-dte-amt,sls-qty)
Write MySQl statement for the following.
Find the number of stores with sale more than the average.
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
Database Concepts
Authors: David M Kroenke, David J Auer
6th Edition
0132742926, 978-0132742924
