Question: I need help with SQL please 1. Find the name and city of the supplier with whom the purchase order number 158 is placed 2.

I need help with SQL please

1. Find the name and city of the supplier with whom the purchase order number 158 is placed

2. Find the names of suppliers that can supply products with product number 154

3. Find the names of suppliers that can supply product type of rose wine

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:

please any help for SQL Query??? 1) Find employee names whose last name start either with a D or C and second last character of first name is either an e or a n. 2) List the department name with the...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

CREATE TABLE REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME CHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), PROVINCE CHAR(3), ZIP CHAR(5), COMMISSION DECIMAL(7,2), RATE DECIMAL(3,2) );...

Q:

Consider the following schema ( primary key fields are underlined ) : Customers ( cid , cname, city ) - cid is the unique identifier for the customer - cname is the name of the customer - city is the...

Q:

help out asap please 1 Count the number of products by Category Name ? Count the number of products by Supplier Name 3 Display Order count by Product Name Display Order count by Category Name Display...

Q:

provide full solution that will get full marks to the paper attached Name: .................................................... Student Number: .................................. Signature:...

Q:

PLEASE HELP WITH QUESTIONS 4-10 CREATE TABLE REP (REP_NUM CHAR(2) PRIMARY KEY, LAST_NAME CHAR(15), FIRST_NAME CHAR(15), STREET CHAR(15), CITY CHAR(15), PROVINCE CHAR(3), ZIP CHAR(5), COMMISSION...

Q:

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

Q:

WVTU is a television station that has 20 thirty-second advertising slots during its regularly scheduled programming each evening. The station is now selling advertising for the first few days in...

Q:

In the midst of closing procedures 1BM Corporation's accountant became ill and was hospitalized. You have volunteered to complete the closing of the books, and you find that all revenue and expense...

Q:

The free - rider problem affects the Question 4 9 options: 1 ) stock market. 2 ) corporate bond market. 3 ) both of the above. 4 ) neither of the above.

Q:

Restful RVs Inc. (RRV) is presently enjoying relatively high growth because of a surge in the demand for recreational vehicles. Management expects earnings and dividends to grow at a rate of 35% for...

Q:

8. Sometimes viewed as a Scandinavian tortilla, these potato flatcakes are often sold in areas with high Scandinavian American populations: a. Lefse b. Lutefisk c. Aquavit d. Fiskepudding

Q:

What is the relationship between humans?

Q:

What is the orientation toward time?