Engineering, 26.02.2020 02:52, Serenitybella

Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name column list_price The list_price column discount_percent The discount_percent column discount_amount A column that’s calculated from the previous two columns discount_price A column that’s calculated from the previous three columns Round the discount_amount and discount_price columns to 2 decimal places. Sort the result set by the discount_price column in descending sequence. Use the LIMIT clause so the result set contains only the first 5 rows.

Answers: 2

Show answers

Other questions on the subject: Engineering

Engineering, 04.07.2019 18:10, yasminothman02

An air conditioning system consist of a 5 cm diameter pipe, operating at a pressure of 200 kpa. the air initially enters the pipe at 15°c with a velocity of 20 m/s and relative humidity of 80%. if the heat supply throughout the process is 960 w, determine the relative humidity and the temperature at the outlet

Answers: 3

continue

Engineering, 04.07.2019 18:10, lowkeyqueenk

Apipe with an outside diameter of 15 cm is exposed to an ambient air and surrounding temperature of -20°c. the pipe has an outer surface temperature of 65°c and an emissivity of 0.85. if the rate of heat loss from the pipe surface is 0.95 kw per meter of length, the external convective heat transfer coefficient (h) is: (a) 12.5 w/m"k (b) 18.6 w/mk (c) 23.7 w/mk (d) 27.9 w/mk (e) 33.5 w/mk

Answers: 1

continue

Engineering, 04.07.2019 19:10, pedropaulofpedrosapp

Tom is having a problem with his washing machine. he notices that the machine vibrates violently at a frequency of 1500 rpm due to an unknown rotating unbalance. the machine is mounted on 4 springs each having a stiffness of 10 kn/m. tom wishes to add an undamped vibration absorber attached by a spring under the machine the machine working frequency ranges between 800 rpm to 2000 rpm and its total mass while loaded is assumed to be 80 kg a) what should be the mass of the absorber added to the machine so that the natural frequency falls outside the working range? b) after a first trial of an absorber using a mass of 35 kg, the amplitude of the oscillation was found to be 10 cm. what is the value of the rotating unbalance? c) using me-3.5 kg. m, find the optimal absorber (by minimizing its mass). what would be the amplitude of the oscillation of the absorber?

Answers: 3

continue

Engineering, 04.07.2019 19:20, qurreab26

A5 kg block of fe is dropped into a very large vat of water. the fe and water initial temperatures are 95 and 25 c, respectively. the fe final temperature is 25 c and the water can be treated as a thermal reservoir,. treated as a thermal reservoir take the water to be the system and determine the entropy generation. report vour answer in kj/k.

Answers: 1

continue

Do you know the correct answer?

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