Question: Answer the three questions in the Multiple Tables Homework Document NOTE: Yellow bar indicates how many records should be returned Create the SQL statements to

Answer the three questions in the Multiple Tables Homework Document

NOTE: Yellow bar indicates how many records should be returned

Create the SQL statements to generate the following report (Partial lists displayed).

A)

Answer the three questions in the Multiple Tables Homework Document NOTE: Yellow

Employee

CompanyName

ContactName

Customer Phone

OrderID

Orderdate

Steven Buchanan

Vins et alcools Chevalier

Paul Henriot

26.47.15.10

10248

1996-07-04

Michael Suyama

Toms Spezialitaten

Karin Josephs

0251-031259

10249

1996-07-05

Margaret Peacock

Hanari Carnes

Mario Pontes

(21) 555-0091

10250

1996-07-08

Janet Leverling

Victuailles en stock

Mary Saveley

78.32.54.86

10251

1996-07-08

B)

bar indicates how many records should be returned Create the SQL statements

Which Customers used United Package as shippers during the month of March 1998?

CompanyName

OrderID

OrderDate

CompanyName

Hanari Carnes

11022

1998-04-14

United Package

Folk och fa HB

11050

1998-04-27

United Package

HILARIoN-Abastos

11055

1998-04-28

United Package

Eastern Connection

11056

1998-04-28

United Package

Franchi S.p.A.

11060

1998-04-30

United Package

Hungry Owl All-Night Grocers

11063

1998-04-30

United Package

White Clover Markets

11066

1998-05-01

United Package

Drachenblut Delikatessen

11067

1998-05-04

United Package

Tortuga Restaurante

11069

1998-05-04

United Package

C)

Which Orders IDs contain products where the Category Name is Beverages?

(Partial list displayed).

to generate the following report (Partial lists displayed). A) Employee CompanyName ContactName

OrderID

ProductID

ProductName

10253

39

Chartreuse verte

10254

24

Guarana Fantastica

10255

2

Chang

10257

39

Chartreuse verte

10258

2

Chang

10260

70

Outback Lager

10261

35

Steeleye Stout

10263

24

Guarana Fantastica

Show transcribed image text

Show query box Showing rows 0 29 (830 total, Query took 0.0008 sec)

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:

Just answer A , B , C include your answers with screen shots of the results. Create a report containing Company names and Orders. Must use 2 tables Customers and Orders Common field is the...

Q:

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

Q:

I have an accounting assignment need to be finished asap. QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 1 2017 Integrated...

Q:

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Q:

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Q:

Income Statement of an interior design firm, Grand Designs, that makes money by selling hours (fees) and by selling furniture or other items (Sale of Goods). 1) Using the formula for Profit Margin,...

Q:

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...

Q:

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Q:

this is the questionplease help me thanksits a project about renovation one level of a building. project management case . This is a renovation project On the basis of group work as a personal...

Q:

Week 2: Understanding and Exploring Assumptions You will submit one Word document, including your SPSS output. 1. Why do we care whether the assumptions required for statistical tests are met? (Tip:...

Q:

In addition to the reasons listed in the chapter, what other issues or events might cause an organization that does not have a formal IS vision recognize the need for developing one?

Q:

Give the title of each of the following: a. Publication 17 b. Publication 225 c. Publication 334

Q:

In property and casuality insurance the combined ratio is equal to q , divided by total premiums writen. Multiple Choice the nominal ratio plus the real ratio the operating ratio minus dividends paid...

Q:

please dont use chat gpt b . 3 8 0 .

Q:

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Q:

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

Q:

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...