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
Calculate the rate at which body heat is conducted through the clothing of a skier in a steady- state process, given the followi
olga2289 [7]

Answer:

230.4W

Explanation:

Heat transfer by conduction consists of the transport of energy in the form of heat through solids, in this case a jacket.

the equation is as follows

Q=\frac{KA(T2-T1)}{L} \\

Where

Q=heat

k=conductivity=0.04

A=Area=1.8m^2

T2=33C

T1=1C

L=thickness=1cm=0.01mQ=\frac{(0.04)(1.8m^2)(33-1)}{0.01m}

Q=230.4W

the skier loses heat at the rate of 230.4W

4 0
3 years ago
Four race cars are traveling on a 2.5-mile tri-oval track. The four cars are traveling at constant speeds of 195 mi/h, 190 mi/h,
Snezhnost [94]

Answer:

Explanation:

1) The number of times, the car with the speed of  195 mph will cross the given point is equal to 30 minutes divided by the time taken by car to cross the 2.5 miles.

0 .5*195/2.5 = 39

Likewise, the car with the speed of 190 mph crosses the point 38 times; the car with the speed of 185 mph crosses the point 37 times

and car with the speed of 180 mph crosses it 36 times

here, the time-mean speed, vt is given below,

vt = (39*195 +38*190+37*185+36*180)/(39+38+37+38)

= 186.433 mph

and space mean speed is given by,

= (39+38+37+36)/(39/195+38/190+37/1850+36/180)

1) The number of times, the car with the speed of  195 mph will cross the given point is equal to 30 minutes divided by the time taken by car to cross the 2.5 miles.

0 .5*195/2.5 = 39

Likewise, the car with the speed of 190 mph crosses the point 38 times; the car with the speed of 185 mph crosses the point 37 times

and car with the speed of 180 mph crosses it 36 times

here, the time-mean speed, vt is given below,

vt = (39*195 +38*190+37*185+36*180)/(39+38+37+38)

= 186.433 mph

and space mean speed is given by,

= (39+38+37+36)/(39/195+38/190+37/1850+36/180)

=187.5 mph

2)  There would be only four number of observations when the aerial photo is given, therefore time mean speed, vt in that condition will be calculated as

Vt = 195+190+185+180/4

  = 187.5

Vs= 4/(1/195+1/190+1/185+1/180)

= 188.36 mph

2)  There would be only four number of observations when the aerial photo is given, therefore time mean speed, vt, in that condition will be calculated as

Vt = 195+190+185+180/4

  = 187.5

Vs= 4/(1/195+1/190+1/185+1/180)

= 188.36 mph

4 0
3 years ago
Problem Statement: Air flows at a rate of 0.1 kg/s through a device as shown below. The pressure and temperature of the air at l
Tema [17]

Answer:

The answer is "+9.05 kw"

Explanation:

In the given question some information is missing which can be given in the following attachment.

The solution to this question can be defined as follows:

let assume that flow is from 1 to 2 then

Q= 1kw

m=0.1 kg/s

From the steady flow energy equation is:

m\{n_1+ \frac{v^2_1}{z}+ gz_1 \}+Q= m \{h_2+ \frac{v^2_2}{2}+ gz_2\}+w\\\\\ change \ energy\\\\0.1[1.005 \times 800]-1= 0.01[1.005\times 700]+w\\\\w= +9.05 \ kw\\\\

If the sign of the work performed is positive, it means the work is done on the surrounding so, that the expected direction of the flow is right.

8 0
2 years ago
What is the 16 diget code to downlod pokemon ultra sun for free on ds
Kazeer [188]

Answer:

2468962218527611

Explanation:

7 0
3 years ago
Read 2 more answers
Which of the following would most likely be operated by a sequential control system?
Rudiy27

Answer:pizza oven

Explanation:

7 0
2 years ago
Read 2 more answers
Other questions:
  • A stone-filled pit used for waste disposal is commonly referred to as a
    15·1 answer
  • A parallel plates capacitor is filled with a dielectric of relative permittivity ε = 12 and a conductivity σ = 10^-10 S/m. The c
    10·1 answer
  • An 80 kg man descends to the ground from an aeroplane using a parachute. If the drag coefficient of the parachute is 0.5 and the
    12·1 answer
  • What is meant by the thickness to chord ratio of an aerofoil?
    12·1 answer
  • Convection ovens operate on the principle of inducing forced convection inside the oven chamber with a fan. A small cake is to b
    6·1 answer
  • A carbon resistor has a resistance of 976 ohms at 0 degrees C. Determine its resistance at 89 degrees C​
    6·1 answer
  • Name the four ways in which heat is transferred from a diesel engine
    7·1 answer
  • Which of the following is an example of a social need?
    5·1 answer
  • Please answer fast. With full step by step solution.​
    14·1 answer
  • What three training organizations are important for Union Masons?
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!