Question

accessНа основе таблицы «Поставки» сформировать запрос о создании нового поля Розничная Цена, в котором подсчитывалось бы численное значение из поля Цена, увеличенное на 20%. Как прописать запрос?

Answer 1

Создаешь в конструкторе запросов

Answer 2

Creating a Query to Add a New Field "Retail Price" Based on the "Supplies" Table

To create a query that adds a new field called "Retail Price" to the "Supplies" table, which calculates the numerical value from the "Price" field increased by 20%, you can use the following SQL statement:

ALTER TABLE Supplies
ADD COLUMN Retail_Price DECIMAL(10, 2);

This query adds a new column named "Retail_Price" to the "Supplies" table with a decimal data type of 10 digits in total, with 2 decimal places.

Next, you can update the values in the "Retail_Price" column by calculating the increased price based on the "Price" field. Here's an example of how you can write the update query:

UPDATE Supplies
SET Retail_Price = Price * 1.2;

This query multiplies the value in the "Price" column by 1.2 (which represents a 20% increase) and assigns the result to the "Retail_Price" column for each row in the "Supplies" table.

Please note that the exact syntax and table/column names may vary depending on the database management system you are using. Make sure to adjust the query accordingly.

Example:

Let's assume we have the following data in the "Supplies" table:

| Product | Price | |---------|-------| | A | 100 | | B | 350 | | C | 200 |

After running the above queries, the "Supplies" table would be updated as follows:

| Product | Price | Retail_Price | |---------|-------|--------------| | A | 100 | 120 | | B | 350 | 420 | | C | 200 | 240 |

The "Retail_Price" column now contains the calculated values based on the "Price" column, increased by 20%.

Please note that the actual implementation may vary depending on the specific database management system and table structure you are working with. It's always a good practice to consult the documentation or seek assistance from a database administrator if needed.

I hope this helps! Let me know if you have any further questions.