Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MySQL query #3 Northwind database, heres a screenshot of the products table: https://gyazo.com/f84d0545e9505755d1545b4a5d480716 3. Return a 3 column result set from the products table: ProductID

MySQL query #3 Northwind database, heres a screenshot of the products table: https://gyazo.com/f84d0545e9505755d1545b4a5d480716

3. Return a 3 column result set from the products table:

ProductID Discontinued - If Discontinued = 1 and UnitsInStock <> 0, return 'Removed', otherwise return value UnitStatus - Find the total inventory monetary amount. Multiplying the UnitPrice and UnitsInStock If less than $400, return 'Low value' If in between $400.01 and $750, return 'Medium value' If more than $750 return 'High value'

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

Database And Expert Systems Applications 33rd International Conference Dexa 2022 Vienna Austria August 22 24 2022 Proceedings Part 2 Lncs 13427

Authors: Christine Strauss ,Alfredo Cuzzocrea ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

3031124251, 978-3031124259

More Books

Students also viewed these Databases questions