Question: What am I doing wrong here?? What condition am I missing? I thought I used the IN operator correctly? Show unique colors for Nike and

What am I doing wrong here?? What condition am I missing? I thought I used the IN operator correctly?

What am I doing wrong here?? What condition am I missing? I

thought I used the IN operator correctly? Show unique colors for Nike

and Apple Bottoms products that are not sneakers, wedges, or heels and

Show unique colors for Nike and Apple Bottoms products that are not sneakers, wedges, or heels and the price is 50 or less. Make sure to use the operator IN. 2 select distinct color from saleitem si JOIN product p ON si.productid =p.productid JOIN manufacturer m ON p.productid =m.manufacturerid where manufacturername in ('Nike', 'Apple Bottom') AND category NOT IN ('sneakers', 'wedges', 'heels') AND listprice

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!

I need help with SQL 11. For each manufacturer (ManufacturerID) show the maximum list price of its products. Show only those manufacturers whose products have an average list price below the average...

1. List the customer first name and last name and the number of orders (name the column NumberOfOrders). List all customers even if they have never placed an order. Order the output by number of...

Customer Product Manufacturer ManufacturerID ManufacturerName Addressi Address2 City State PostalCode Phone Fax Contact URL Sale Saleltem CustomerID FirstName LastName StreetAddress City State...

1 2 Show unique colors for Nike and Apple Bottoms products that are not sneakers, wedges, or heels and the price is 5 0 or less. Make sure to use the operator IN .

Show unique colors for Nike and Apple Bottoms products that are not sneakers, wedges, or heels and the price is 5 0 or less. Make sure to use the operator IN .

1 2 Show unique colors for Nike and Apple Bottoms products that are not sneakers, wedges, or heels and the price is 5 0 or less. Make sure to use the operator IN .

Please be sure to not copy any answers verbatim. original answers needed will be scanned through the safe-assign system. read the Marketing Debate below What is the Best Way to Position a brand? and...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

It was 3 a.m. when the wake-up call startled Steve McKenzie out of deep sleep. McKenzie, a management consultant from New Jersey, was glad to be finally leaving the Bon Star Hotel, a three-star hotel...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

In a particular year PepsiCos earnings either rose or fell, depending on the source of the information. Standard & Poors reported that PepsiCo experienced a 25 percent earnings gain, while Value...

You have recently been appointed as the Store Manager of the Australian Hardware Newcastle store. You and the COO (Chief Operating Officer) have discussed opportunities for you to make an impact and...

Discussion Question 1 - CLO 1, CLO 6 Louise and Christopher Maclin live in the U.K. and currently rent an apartment in London's metropolitan area. During an initial discussion of the Maclins'...

Which one of the following is a period cost? Salaries paid to assembly line workers Rent paid on the office building Taxes paid on the factory building Utilities paid on the factory building

3. Did you seek anyones advice?

7. What traps should she avoid?

5. What decision-making model would you advocate to this person?