Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2014 Nancy France September 15 19 2014 Proceedings Part 3 Lnai 8726

Authors: Toon Calders ,Floriana Esposito ,Eyke Hullermeier ,Rosa Meo

2014th Edition

3662448440, 978-3662448441

More Books

Students also viewed these Databases questions