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
An experiment to determine the convection coefficient associated with airflow over the surface of a thick stainless steel castin
Maksim231197 [3]

Answer:

h = 375 KW/m^2K

Explanation:

Given:

Thermo-couple distances: L_1 = 10 mm , L_2 = 20 mm

steel thermal conductivity k = 15 W / mK

Thermo-couple temperature measurements: T_1 = 50 C , T_2 = 40 C

Air Temp T_∞ = 100 C

Assuming there are no other energy sources, energy balance equation is:

                                               E_in = E_out

                                        q"_cond = q"_conv

Since, its a case 1-D steady state conduction, the total heat transfer rate can be found from Fourier's Law for surfaces 1 and 2

q"_cond = k * (T_1 - T_2) / (L_2 - L_1) = 15 * (50 - 40) / (0.02 - 0.01)

=15KW/m^2

Assuming SS is solid, temperature at the surface exposed to air will be 60 C since its gradient is linear in the case of conduction, and there are two temperatures given in the problem. Convection coefficient can be found from Newton's Law of cooling:

q"_conv = h * ( T_∞  - T_s ) ----> h = q"_conv / ( T_∞  - T_s )

                                                   h = 15000 W / (100 - 60 ) C = 375 KW/m^2K

4 0
3 years ago
A pinion and gear pair is used to transmit a power of 5000 W. The teeth numbers of pinion
tester [92]

Answer:

mark me as a brainleast

Explanation:

209781

6 0
2 years ago
What is polarized electrical receptacle used for
lidiya [134]

Answer:

they are used for electrical currents so that they can flow along the appropriate wires in the circuit

Explanation:

4 0
3 years ago
Engineers in Russia invented a new way to create colorful art with a __________.
Setler [38]

The Engineers in Russia invented a new way to create colorful art with constructivist art.

<h3>What is constructivist art?</h3>

Constructivist art was aimed to reflect modern industrial society and urban space in art. It uses industrial production forms and modest materials for its art production.

The constructivists proposed to replace traditional art's with a focus on construction as Engineers rather than a painter.

Therefore, the Engineers in Russia invented a new way to create colorful art with constructivist art using construction.

Learn more on constructivist here,

brainly.com/question/14054863

3 0
3 years ago
If the channel-Length modulation effect is neglected, ID in the saturation region is considered to be independent of VDS
djverab [1.8K]
The answer is true because if the effect is neglected, the saturation id region is considered true
4 0
3 years ago
Other questions:
  • Given int variables k and total that have already been declared, use a do...while loop to compute the sum of the squares of the
    15·1 answer
  • An air conditioner using refrigerant R-134a as the working fluid and operating on the ideal vapor-compression refrigeration cycl
    12·1 answer
  • Answer the following questions, and very briefly explain your answer:
    5·1 answer
  • Block A has a weight of 8 lb. and block B has a weight of 6 lb. They rest on a surface for which the coefficient of kinetic fric
    8·1 answer
  • A satellite would have a mass of 270 kg on the surface of Mars. Determine the weight of the satellite in pounds if it is in orbi
    12·1 answer
  • What is the role of the architects in modern development​
    15·1 answer
  • which systems engineering support discipline has the goal to ensure that support considerations are an integral part of the syst
    14·1 answer
  • Which of the following is not true about manufacturing employment in the U.S?
    15·1 answer
  • Technician A says that acid core solder should be used whenever aluminum wires are to be soldered.
    14·1 answer
  • 7. If you can't ignore a distraction, what should you do?
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!