You need to create a table named OrderDetails on a new server. OrderDetails must meet the
following requirements:
– Contain a new column named LineltemTotal that stores the product of
ListPrice and Quantity for each row.
– The calculation for a line item total must not be run every time the
table is queried.

– The code must NOT use any object delimiters.
The solution must ensure that LineltemTotal is stored as the last column in the table. Part of the
correct T- SQL statement has been provided in the answer area. Provide the complete code.

Answer: See the explanation

Explanation:
CREATE TABLE OrderDetails
(
ListPrice money NOT NULL,
Quantity int NOT NULL,
LineItemTotal AS (ListPrice * Quantity) PERSISTED
)