id  name   price   quantity   total

1     food    50      1         50
2     drink   20      2         40
3     dress   100     3         300

CREATE TABLE [dbo].[Orders] (
    [Id]          INT        IDENTITY (1, 1) NOT NULL,
    [ProductName] NCHAR (70) NULL,
    [Price]       INT        NULL,
    [Quantity]    INT        NULL,
    [Total] INT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

CREATE TABLE [dbo].[Orders] (
    [Id]          INT        IDENTITY (1, 1) NOT NULL,
    [ProductName] NCHAR (70) NULL,
    [Price]       INT        NOT NULL,
    [Quantity]    INT        NOT NULL,
    [Total] INT AS (Price * Quantity),
    PRIMARY KEY CLUSTERED ([Id] ASC)
);