Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help on this database SQL questions refer to the table given. Thank you 1. List road bicycle sale prices which are greater than
I need help on this database SQL questions refer to the table given. Thank you
1. List road bicycle sale prices which are greater than the average sale price sold in 2011. List these bikes with the most expensive on the top.
2. Which cities in California do not have retail stores in them.
3. Which customer(s) purchased the most number of bicycles in a single month. Hint Use the format function: format(orderdate, yyyy-MM) to group sales into a single month value.
Customer TubeMaterial BikeTubes ModelType Tube Name Component Groupl Paint ColorStyle Totallength WaterBottleBr azeOn HeadTubeAngle Manufact urerlD CustomerTrans Category LetterStylelD Datelnstalled TransactionDate StorelD ZIPCode CitylD Quantity Received ReceiveDate Manufacturer Manufacturer Trans WorkArea Manufactu rerlD Manufacturer Name Description ZIPCode
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