1 and 2 question: - create database temp:

CREATE TABLE Product (

ProductID INT PRIMARY KEY,

ProductName VARCHAR (100) NOT NULL, no items INT DEFAULI O, rate_per item INT,

total_price INI GENERATED ALWAYS AS (rate per_item * no items) STORED) :

3. INSERT INTO Product (ProductID, ProductName, no items, rate_per item)

VALUES (1001,

'Prale G', 50, 10);

(1002,

'Product B', 20, 25),

(1003,

*Product_C'. 30, 35).

(1004,

"Product D',

(1005, Product E', 50, 55):

4. :- select - from product where ProductID = * 1005*;

5） ：- apdate produet set zate_per_iten = eo where ProduetiD i12003'：

：- select ProductName, total price trom product wheze ProductID =-10011：

7)

：- delete from produet Where ProductID ="1004 ：

8. :- select ProductName from product: