SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- Create Products Table
CREATE TABLE Products (
    ProductID INT PRIMARY KEY,
    ProductName VARCHAR(50),
    Color VARCHAR(50),
    Price DECIMAL(10, 2)
);

-- Insert data into Products Table
INSERT INTO Products (ProductID, ProductName, Color, Price)
VALUES
    (101, 'Product A', 'Blue', 10.00),
    (102, 'Product B', 'Red', 15.00),
    (103, 'Product C', 'White', 20.00);

-- Create Orders Table
CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    ProductID INT,
    Quantity INT,
    FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
);

-- Insert data into Orders Table
INSERT INTO Orders (OrderID, ProductID, Quantity)
VALUES
    (1, 101, 51),
    (2, 102, 50),
    (3, 103, 2);
6 rows affected

SELECT * FROM Products;


ProductID
ProductName
Color
Price


101
Product A
Blue
10.00

102
Product B
Red
15.00

103
Product C
White
20.00


SELECT * FROM Orders;


OrderID
ProductID
Quantity


1
101
51

2
102
50

3
103
2


UPDATE Products
SET Price = Price * 1.04 -- Increase price by 4%
FROM Products
INNER JOIN (
	SELECT ProductID
	FROM Orders
	GROUP BY ProductID
	HAVING SUM(Quantity) > 5
	) AS HighDemandProducts ON Products.ProductID = HighDemandProducts.ProductID
WHERE Products.Color = 'Blue';
1 rows affected

SELECT * FROM Products;


ProductID
ProductName
Color
Price


101
Product A
Blue
10.40

102
Product B
Red
15.00

103
Product C
White
20.00

ProductID	ProductName	Color	Price
101	Product A	Blue	10.00
102	Product B	Red	15.00
103	Product C	White	20.00

ProductID	ProductName	Color	Price
101	Product A	Blue	10.40
102	Product B	Red	15.00
103	Product C	White	20.00