A. For a 200g load acting vertically downwards at point B’, determine the axial load in members A’B’, B’C’, B’D’, C’D’ and C’E’.

Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name column

I am Lyosha [343]

Answer:

SELECT

product_name, list_price, discount_percent,

ROUND(list_price * (discount_percent / 100), 2) AS discount_amount,

ROUND(list_price - (discount_percent / 100 * list_price), 2) AS discount_price

FROM

Products

ORDER BY (list_price - (discount_percent / 100 * list_price)) DESC

LIMIT 5;

Explanation:

In the above SELECT statement is used to select columns from Products table.

The columns are product_name,list_price and discount_percent

Next a column discount_amount is selected which is the calculated from previous two columns that are list_price and discount_percent. The discount amount is basically calculated by multiplying list_price with discount_percent/100 and the resultant column is named as discount_amount using Alias which is used to give a temporary name to set of columns or a table.

Next another column discount_price is obtained from previous three columns that are list_price , discount_percent and discount_amount as: list_price - (discount_percent / 100 * list_price) This as a whole is given a column name discount_price.

FROM is used to refer to a table from which these columns are to be selected. The table name is Product.

The result set is sorted in descending order by discount_price so ORDER BY is used to order the resultant records and DESC is used to sort these records according to the discount_price in descending order.

LIMIT statement is used to extract the records from Product and limit the number of rows returned as a result based on a limit value which is 5 here.

5 0

3 years ago

How large a force is required to accelerate a 1300 kg car from rest to a speed of 20 m/s in a distance of 80 m?

topjm [15]

F=m*a

F=80*20

F =1600 ans"

7 0

3 years ago

Read 2 more answers

You are traveling upstream on a river at dusk. You see a buoy with the number 5 and a flashing green light . What should you do?

nalin [4]

Answer:

please give brainliest my brother just got the corona virus

Explanation:

this is my brothers account he wants to get 5 brainliest

8 0

3 years ago

Water at 200C flows through a pipe of 10 mm diameter pipe at 1 m/s. Is the flow Turbulent ? a. Yes b. No

Degger [83]

Answer:

Yes, the flow is turbulent.

Explanation:

Reynolds number gives the nature of flow. If he Reynolds number is less than 2000 then the flow is laminar else turbulent.

Given:

Diameter of pipe is 10mm.

Velocity of the pipe is 1m/s.

Temperature of water is 200°C.

The kinematic viscosity at temperature 200°C is $1.557\times10^{-7}$ m2/s.

Calculation:

Step1

Expression for Reynolds number is given as follows:

$Re=\frac{vd}{\nu}$

Here, v is velocity, $\nu$ is kinematic viscosity, d is diameter and Re is Reynolds number.

Substitute the values in the above equation as follows:

$Re=\frac{vd}{\nu}$

$Re=\frac{1\times(10mm)(\frac{1m}{1000mm})}{1.557\times10^{-7}}$

Re=64226.07579

Thus, the Reynolds number is 64226.07579. This is greater than 2000.

Hence, the given flow is turbulent flow.

5 0

3 years ago

If a worksite includes more than one set of management and workers, who should have access to the information, training, and con

Elden [556K]

Answer:

In a work site with more than one set of management and workers the Health and safety officers in each set should have access to the information, training and controls needed to avoid workplace accidents

Explanation:

The primary aim of a health and safety officer in a workplace is to prevent accidents,injuries and work-related sickness from occurring in the work site by creating and implementing health and safety policies according to international standards and also ensure that these policies are implemented by the sets of management and workers/staffs of the work site. to achieve these they therefore should have access to the information,training and controls needed to avoid workplace accidents

4 0

3 years ago

Read 2 more answers