In the figure show, what's the distance from point H to point C?

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

Tahir travel twice as far as ahmed, but onley one third as fast. Ahmed starts travel on tuesday at noon at point x to point z 30

shepuryov [24]

Answer:

6:00 pm the next day

Explanation:

Given that

Tahir traveled twice as far as Ahmed. We say,

Ahmed traveled a distance, D

Tahir would travel a distan, 2D

Tahir traveled 1/3 as fast as Ahmed, so we say

Ahmed traveled at a speed, S

Tahir would travel at a speed, S/3

If Ahmed starts travel on tuesday at noon at point x to point z 300km, by 9:00pm,

Time taken by Ahmed to travel is

9:00 pm - 12:00 pm = 9 hours

Ahmed, traveled 300 km in 9 hours, meaning he traveled at 33.3 km in an hour.

Speed, S that Ahmed traveled with is 33.3 km/h

Remember, we stated that Tahir travels at a speed of S/3, that is, The speed of Tahir is

33.3/3 = 11.1 km/h.

300 km would then be traveled in 300 km/11.1 km/h = 27 hours.

Tahir started traveling, 3 hours after Ahmed, that is 12:00 pm + 3:00 hrs = 3:00 pm, and if he's to spend 27 hours on the journey he would reach destination z at 6:00 pm the next day

7 0

3 years ago

What is differentiation

oksian1 [2.3K]

Answer:

the action or process of differentiating or distinguishing between two or more things or people.

7 0

3 years ago

A pin fin of uniform cross-sectional area is fabricated of an aluminum alloy (k = 160W m-1 K-1 ). The fin diameter is D = 4 mm,

disa [49]

Answer: (a) 36.18mm

(b) 23.52

Explanation: see attachment

4 0

4 years ago

Which of the following is NOT true about hydraulic valves? A. Directional control valves determine the path of a fluid in a give

Lelechka [254]

Answer: Option D is not true of hydraulic valves. A hydraulic valve is a device that can change the opening degree of liquid flow path

Explanation:

The pilot check valve allows flow of liquid in one direction and blocks flow in the opposite direction

5 0

4 years ago