CASE_Query_Errors.docx CASE Query Errors MIS-610 Query Scenarios Problem One Your manager needs you to compile a list of all the products the company sells as well as the time required to manufacture them in or
...
CASE_Query_Errors.docx CASE Query Errors MIS-610 Query Scenarios Problem One Your manager needs you to compile a list of all the products the company sells as well as the time required to manufacture them in order to provide this information to the sales department for the presentation of timelines in an upcoming company-wide sales meeting. Your manager specifically needs to know which products take (1) less than 4 days to manufacture, or (2) more than 4 days to manufacture. Looking at the "Production.Product" and using CASE logic, identify each product with a tag of "Under 4 days" or "More than 4 days" and title the field "Timeframe." SELECTProductID,Name,DaystoManufacture, CASE WHENDaystoManufacture>=4 THEN'4 or Over' --Greater than or equal chosen because there are no >4 value ELSE'3 or Under'ENDASTimeFrame FROMProduction.Product Problem Two Using the query you created from Problem One as a basis, your manager wants to know the numbers of products that fall into each of the two categories. Note:Â This process requires two separate SUM statements using CASE logic through the "Manufacturing time." SELECT SUM ( CASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . .. .. . . . . . . . . . . . . . . . . . .. . . . .
[Show More]