Answered step by step
Verified Expert Solution
Question
1 Approved Answer
/* (5) Question #2: Fix the following query. It should return 13 rows, first one is USB food flash drive - banana */ SELECT SI.StockItemID,
/* (5) Question #2: Fix the following query. It should return
13 rows, first one is "USB food flash drive - banana"
*/
SELECT
SI.StockItemID,
SI.StockItemName AS [ItemForSales],
SI.ColorID AS [Color]
FROM
Warehouse.StockItems SI
ORDER BY
ItemForSales
WHERE
SI.ColorID = NULL
AND
SI.StockItemName LIKE '%USB%'
my error :
Msg 156, Level 15, State 1, Line 12 Incorrect syntax near the keyword 'WHERE'.
What is causing my error?
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