Answered step by step
Verified Expert Solution
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
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