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 ;
1 answer:
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
Answer:
Tech B
Explanation:
Horsepower (hp) refers to a unit of measurement of power in respect of the output of engines or motors.
Horsepower is the common unit of power. It indicates the rate at which work is done.
The formula , where rpm is the engine speed, T is the torque, and 5,252 is radians per second.
So,
Tech B is correct
Answer:
battery life in year = 9 years and 48 days
Explanation:
given data
Battery Ampere-hours = 1.5
Pulse voltage = 2 V
Pulse width = 1.5 m sec
Pulse time period = 1 sec
Electrode heart resistance = 150 Ω
Current drain on the battery = 1.25 µA
to find out
battery life in years
solution
we get first here duty cycle that is express as
duty cycle = ...............1
duty cycle = 1.5 ×
and applied voltage will be
applied voltage = duty energy × voltage ...........2
applied voltage = 1.5 × × 2
applied voltage = 3 mV
so current will be
current = ................3
current =
current = 20 µA
so net current will be
net current = 20 - 1.25
net current = 18.75 µA
so battery life will be
battery life =
battery life = 80000 hours
battery life in year =
battery life in year = 9.13 years
battery life in year = 9 years and 48 days