1)

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

Line.

Veronika [31]

Air supplied to a pneumatic system is supplied through the C. Actuator

Explanation

Pneumatic systems are like hydraulic systems, it is just that these systems uses compressed air rather than hydraulic fluid. Pneumatic systems are used widely across the industries. these pneumatic systems needs a constant supply of compressed air to operate. This is provided by an air compressor. The compressor sucks in air at a very high rate from the environment and stores it in a pressurized tank. the Air is supplied thereafter with the help of a actuator valve that is a more sophisticated form of a valve.

From the above statement it is clear that Air supplied to a pneumatic system is supplied through the Actuator

7 0

3 years ago

What are the factors of production in business? Land, labor, and capital land, capital, and interest land, labor, and customer b

kozerog [31]

Answer:

 Land, labor, and capital

Explanation:

The factors of production are the resources that are used to produce goods and services.

By definition resources are scarce.

Land includes everything that comes from the land, that can be used as raw material to produce other materials; for instance, water, minerals, wood.

Labor is the work done by anybody, not just at a factory but at any enterpise that produce a good or a service. For instance, the work done by a person in a bank or a restaurant.

Capital is the facilites (buildings), machinery, equipments, tools that the persons use to produce goods or services. For instance, a computer, a chemical reactor, or a pencil.

Nowadays, also entrepreneurship is included as a factor of production, since it is the innovative skill of the entrepeneurs to combine land, labor and capital what permit the production of good and services.

6 0

3 years ago

Read 2 more answers

Briefly explain how each of the following influences the tensile modulus of a semicrystalline polymer and why:(a) molecular weig

marin [14]

Answer:

(a) Increases

(b) Increases

(c) Increases

(d) Increases

(e) Decreases

Explanation:

The tensile modulus of a semi-crystalline polymer depends on the given factors as:

(a) Molecular Weight:

It increases with the increase in the molecular weight of the polymer.

(b) Degree of crystallinity:

Tensile strength of the semi-crystalline polymer increases with the increase in the degree of crystallinity of the polymer.

(c) Deformation by drawing:

The deformation by drawing in the polymer results in the finely oriented chain structure of the polymer with the greater inter chain secondary bonding structure resulting in the increase in the tensile strength of the polymer.

(d) Annealing of an undeformed material:

This also results in an increase in the tensile strength of the material.

(e) Annealing of a drawn material:

A semi crystalline material which is drawn when annealed results in the decreased tensile strength of the material.

5 0

3 years ago

Write a Nios II assembly program that reads binary data from the Slider Switches, SW11-0, on the DE2-115 Simulator, and display

Citrus2011 [14]

Algorithm of the Nios II assembly program.

Attain data for simulation from the SW11-0, on the DE2-115 Simulator
The data will be read from the switches in loop.
The decimal output is displayed using the seven-segment displays and done using the loop.
The program is ended by the user operating the SW1 switch

and

The decimal equivalent on the seven-segment displays HEX3-0 is

DE2-115
DE2-115_SW11
DE2-115_HEX3
DE2-115_HEX4
DE2-115_HEX5
DE2-115_HEX6
DE2-115_HEX7

<h3>The Algorithm and decimal equivalent on the seven-segment displays HEX3-0</h3>

Generally, the program will be written using a cpulator simulator in order to attain best result.

We are to

Attain data for simulation from the SW11-0, on the DE2-115 Simulator
The data will be read from the switches in loop.
The decimal output is displayed using the seven-segment displays and done using the loop.
The program is ended by the user operating the SW1 switch

This will be the Algorithm of the Nios II assembly program .

Hence, the decimal equivalent on the seven-segment displays HEX3-0 is

DE2-115
DE2-115_SW11
DE2-115_HEX3
DE2-115_HEX4
DE2-115_HEX5
DE2-115_HEX6
DE2-115_HEX7

For more information on Algorithm

brainly.com/question/11623795

6 0

2 years ago