Answered step by step
Verified Expert Solution
Question
1 Approved Answer
write a sql querry Adventure works sales team wants locationid,locationname,amount and ratings of location to be displayed as follows location name should be first 3
write a sql querry Adventure works sales team wants locationid,locationname,amount and ratings of location to be displayed as follows location name should be first 3 letters of location name in capital and the rating value should be display as next highest number. Ex1 -if rating value is 4 or4.0 then whole rating should be 4.0 2-if rating is 4.3 then whole rating should be 5.0
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