sql quries with northwind database for this ques

In a transaction: a. Create a new category named 'Personal Hygiene' in categories table. Provide appropriate description. b. Create a save point pl. c. Create a product 'Axe deodorant body spray. Use supplier id as 7, quantity as 250 ml, Unit price as 5.5, Units in stock as 100, unitsonorder, reorderlevel and discontinued as 0. Use appropriate product ID, category ID. d. Create a save point p2. e. Create an order for the newly created product. i. Order created for customer 'COMMI' ii. Employee ID -9 iii. Order date, required date and shipped date as current timestamp iv. ShipVia - 3 v. Freight -0.2 vi. ShipName-reggiani caseifici, ship address - Strada Provinciale 124, Ship City - Reggio Emilia, Ship postal code 42100, Ship Country - Italy. f. Create an entry in orderdetails table for the corresponding order id. i. Use appropriate ID ii. Unit price as 5.25 iii. Quantity - 100 iv. Discount - 0 g. Roll back to save point p2. h. Commit the transaction. In a transaction: a. Create a new category named 'Personal Hygiene' in categories table. Provide appropriate description. b. Create a save point pl. c. Create a product 'Axe deodorant body spray. Use supplier id as 7, quantity as 250 ml, Unit price as 5.5, Units in stock as 100, unitsonorder, reorderlevel and discontinued as 0. Use appropriate product ID, category ID. d. Create a save point p2. e. Create an order for the newly created product. i. Order created for customer 'COMMI' ii. Employee ID -9 iii. Order date, required date and shipped date as current timestamp iv. ShipVia - 3 v. Freight -0.2 vi. ShipName-reggiani caseifici, ship address - Strada Provinciale 124, Ship City - Reggio Emilia, Ship postal code 42100, Ship Country - Italy. f. Create an entry in orderdetails table for the corresponding order id. i. Use appropriate ID ii. Unit price as 5.25 iii. Quantity - 100 iv. Discount - 0 g. Roll back to save point p2. h. Commit the transaction