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
Give me top 5 British snacks
tia_tia [17]

Answer:

1. Mini Cheddars

2. Sausage Roll

3. Monster Munch

4. Cheese Twists

5. Flapjacks

6 0
2 years ago
Technician A says that a voltage drop of 0.8 volts on the starter ground circuit is within specifications. Technician B says tha
Romashka-Z-Leto [24]

Answer:

Technician A is wrong

Technician B is right

Explanation:

voltage drop of 0.8 volts on the starter ground circuit is not within specifications. Voltage drop should be within the range of 0.2 V to 0.6 V but not more than that.

A spun bearing can seize itself around the crankshaft journal causing it not to move. As the car ignition system is turned on, the stater may draw high current in order to counter this seizure.

8 0
3 years ago
What are the two main what are the two main concerns in the research of fluid power efficiency?
Galina-37 [17]

Answer:

The correct option is;

Materials and Components

Explanation:

The efficiency of fluid power is influenced by the components and the materials used to deliver the power of the fluid as such fluid power control are focused on

1) Advances in fluid power

2) Making use of the advantages

3) Making use of the other externally available technological advantages

4) Giving allowance for disadvantages

Areas of interest in advances in fluid power are;

a. Computer optimized flow

b. The use of new and improved materials/coatings

c. The use of components that save energy, such as intelligent supply pressure adapting systems

3 0
2 years ago
Read 2 more answers
Before cutting coarse screw threads, the operator should lubricate: A. The leadscrew and gearbox B. The ways and cross slide C.
Maksim231197 [3]

Answer:

(d) all of the above

Explanation:

before cutting the screw threads the operator should lubricate all of the machine parts given in the option that is lead screw and gearbox , the ways and the cross slide and the carriage and half-nuts. we should use lubrication because it reduces the overall system friction and if friction is reduced then heat generated due to friction is also decreases which is beneficial

so option (D) will be correct because we need lubricate in all the given parts  

8 0
3 years ago
How much force is required if the ramp is 15 ft long
lord [1]

Answer:

do yah stiil need help

Explanation:

6 0
3 years ago
Other questions:
  • Select the correct answer.
    7·1 answer
  • Please read
    6·1 answer
  • A sludge pump pumps at a rate of 40 GPM. The raw sludge density is 4.5 percent solids. How many minutes per hour should the pump
    11·1 answer
  • A commuter train traveling at 50 mi/h is 3 mi from a station. The train then decelerates so that its speed is 15 mi/h when it is
    9·1 answer
  • You just purchased a 400-L rigid tank for a client who works in the gas industry. The tank is delivered pre-filled with 3 kg of
    8·1 answer
  • A spherical tank for storing gas under pressure is 25 m in diameter and is made of steel 15 mm thick. The yield point of the mat
    5·2 answers
  • During genetic engineering, how do Restriction enzymes know what base pairs to act on?
    10·1 answer
  • What is the ideal cooling system for low horsepower motor? For example1hp motor
    9·1 answer
  • Why do engineers play a variety of roles in the engineering process?
    6·1 answer
  • How are sedimentary - gravity flows different from fluid - gravity flows
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!