How can I INSERT the value of TotalPrice by calculating automatically by (quantity*price) from Items table and Order table : CREATE TABLE Items(
ID INT IDENTITY(1,1) PRIMARY KEY,
Name VARCHAR(50),
Price FLOAT
)

CREATE TABLE Customers
(
Id INT IDENTITY(1,1) PRIMARY KEY,
Name VARCHAR(50),
[Address] VARCHAR(200),
Contact VARCHAR(50),
)

CREATE TABLE Orders
(
Id INT IDENTITY(1,1) PRIMARY KEY,
CustomerId INT FOREIGN KEY REFERENCES Customers(Id),
ItemId INT FOREIGN KEY REFERENCES Items(Id),
Quantity INT,
TotalPrice FLOAT
)
