Question: /* (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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Using the PDF File, the Excel sheet needs to be completed. Master Budget Modeling Project for MyArmor, Inc. - 2017 Planning Year Project is Activated Save your project by following these directions -...

Q:

Using the attached and the unit reading assignment, explore the capital budgeting techniques covered in the unit, NPV, PI, IRR, and Payback. Compare and contrast each of the techniques with an...

Q:

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Q:

These are what my teacher expects for a strategic analysis essay: "Strategic Case Analyses - Case studies provide important windows into the real problems that firms are trying to solve. Note, since...

Q:

QUESTION 1 Could you give me _______ hint on the answer? a an the no article QUESTION 2 Fix the following sentence: I'd really like to travel to Southeast Asia, however, the flight is really long and...

Q:

Question 1 (2 points) When fully factored, the following polynomial has four factors. Choose which four factors give the correct factoring of: F(X) - -x3-x+6x 0-1 DO (x - 4) (x +4) [ (x - 5) Xx +5...

Q:

Pls help the following questions STUDY AREA 1 TEGRATION : EXTRA EXERCISES Question 1 -t Find exactly the average value of a function y = 2109? over the interval [0, 5]. Question 2 Velocity of an...

Q:

A breakfast cereal manufacturer obtains its raw materials from a single supplier. The raw material costs around 7 5 per tonne. Demand is reasonably constant throughout the year, and last year the...

Q:

When a cost base does not change regardless of the activity the cost is a fixed cost. True False 1 points QUESTION 2 Fix cost does not remain consistent when activity changes. True False 1 points...

Q:

Suppose that the dollar to euro exchange rate is $1.25 = 1.00 and the dollar to yen exchange rate is 100 = $1.00. What is the euro to yen cross rate?

Q:

One process supported by the IT department at Eco-Friendly Cleaners is the process of managing customer appointments. This process involves receiving and scheduling customer requests for cleaning...

Q:

binary to grey code only nor gates and using one J / K Flip Flop, one T Flip Flop, and one D Flip Flop

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

9-10 In this exercise, youll use database software to develop an application that tracks customer service requests and analyzes customer data to identify customers meriting priority treatment. Prime...

Q:

9-13 Why did WIM feel the need to implement an ERP system? Welding Industries Malaysia (WIM) is the only local Malasian company that manufactures welding machines for commercial use. WIMs remarkable...

Q:

9-17 What are 3 reasons why a company would want to implement an enterprise resource planning (ERP) system and two reasons why it might not want to do so.