1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
elena-s [515]
3 years ago
10

Considering the two tables below called Orders and OrderLines, how many rows would be returned by this SQL query? SELECT o.Order

ID, ol.OrderLineID FROM Orders AS o LEFT JOIN OrderLines AS ol ON o.OrderID = ol.OrderID ;

Engineering
1 answer:
natima [27]3 years ago
3 0

Answer:

The query will return four (4) rows

Explanation:

(See attachment below for the table)

The query will return rows where ORDERID is the same on both tables i.e. table ORDERS and ORDERLINES.

The similar rows (on column ORDERID) are 1897 and 87; for table ORDERLINESS and table ORDERS.

But on table ORDERLINESS, there are three rows with 1897 (under ORDERID column).

In total, they have 4 rows in common which are

ORDERID

1897

1897

1897 and

87

You might be interested in
What process is used to remove collodal and dissolved organic matter in waste water ​
Juli2301 [7.4K]

Answer:

Aerobic biological treatment process

Explanation:

Aerobic biological treatment process in which micro-organisms, in the presence of oxygen, metabolize organic waste matter in the water, thereby producing more micro-organisms and inorganic waste matter like CO₂, NH₃ and H₂O.

3 0
3 years ago
Please help me with this, picture.
Alenkasestr [34]
Maybe try 086 degrees
3 0
2 years ago
A completely reversible heat pump produces heat ata rate of 300 kW to warm a house maintained at 24°C. Theexterior air, which is
Triss [41]

Answer:

Change in entropy S = 0.061

Second law of thermodynamics is satisfied since there is an increase in entropy

Explanation:

Heat Q = 300 kW

T2 = 24°C = 297 K

T1 = 7°C = 280 K

Change in entropy =

S = Q(1/T1 - 1/T2)

= 300(1/280 - 1/297) = 0.061

There is a positive increase in entropy so the second law is satisfied.

6 0
3 years ago
You work for a printing company, and you realize that your colleague sent incorrect price quotes to a client. You begin to write
xxTIMURxx [149]

Answer:

The sentence excerpted from the e-mail uses passive voice.  

Given the  purpose of your message, this voice is appropriate.

Explanation:

Because the objective is to remedy the situation a passive voice is great because it emphasizes the action and the object instead of the subject.

We want to emphasize the document and the incorrect information, not our colleague.

4 0
3 years ago
__________<br> is an accurate way of drawing that shows an object's<br> true size and shape.
Bingel [31]
ANSWER:

Detail drawing
6 0
3 years ago
Other questions:
  • ): drivers must slow down from 60 to 40 mi/hr to negotiate a severe curve. A warning sign is visible for a distance of 120 ft. H
    7·1 answer
  • The wet density of a sand was found to be 1.9 Mg/m3 and the field water content was 10%. In the laboratory, the density of solid
    9·1 answer
  • Consider a system with two tasks, Task1 and Task2. Task1 has a period of 200 ms, and Task2 has a period of 300 ms. All tasks ini
    5·1 answer
  • Can anybody teach me how to make an app with flask and pygame together?​
    10·1 answer
  • Question 5
    7·2 answers
  • What is your employer required to have on fixed ladders that extend more than 24 feet in the workplace?
    15·2 answers
  • Consider the titration of 100.0 mL of 0.200 M CH3NH2 by 0.100 M HCl.
    13·1 answer
  • Introduction for site visit​
    13·1 answer
  • if stall speed in ktas for an aircraft us 100 ktas at sea level, what is the stall speed in ktas of the aircraft at 5000 ft dens
    7·1 answer
  • An ideal Diesel Cycle has a compression ratio of 18 and a cutoff ratio of 1.5. Determine the maximum air temperature and the rat
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!