Examples of change / update requests can be used for a workshop on SQL queries.

Query U001. The following SQL change request increases the prices for products with code 3 in the m_income table by 10%:

UPDATE m_income SET price = price*1.1
WHERE product_id=3;

Query U002. The following SQL update request increases the number of all products in the m_income table by 22 units, the names of which begin with the word "Oil" ("Масло"):

UPDATE m_income SET amount = amount+22
WHERE product_id IN (SELECT id FROM m_product WHERE title LIKE "Масло*");

Query U003. The following SQL change request in the m_outcome table reduces by 2% the price of all products, which are produced by LLC "Sladkoe":

UPDATE m_outcome SET price = price*0.98
WHERE product_id IN 
(SELECT a.id FROM m_product a INNER JOIN m_supplier b 
ON a.supplier_id=b.id WHERE b.title='ООО "Сладкое"');