sql server code

Add a new Person: - Ist, insert a new Builinessentity record. The only field you need to include is the Modified Date held. The others will be populated automatically. - Second, add a person - Use the BuninessEntityID recond you created in previous step. - Person Type is 't - Use your name for First, Middie, and Last. - Skip any field not needed. Add an address for your new personc - 1st, insert the Address Line 1, City, StateProvincelD lyou need to look this value uph, and Postal Code for your favorite physical store. - Add the address you fust created to the Businessentityaddress and tie it to the user you previously created. Add an order: - OrderDate is today - DueDate is 1 weck in the future - Status is 1 - Bal To Address and Ship To Address are both the address added above. - Ship Method is 'CARGO TRANSPORT 5' Add the foliowing items to the order above usine Special Offer ib of 1 : - 3 x Water Eattle - 30 ot. (WB-H098) - 1 Cable Lock 1LO-C100) - 2 Men's 5oorts Sharte, M iSH.M897.MI - 4 Longislecve Logo Jersey, M (LL-0192-M) - 'Uhe the tht Price from the product to populate the ListPrice held and alsa caleulate the LineTotal ficid. Update the order to indude- - Subtotal lealeulated froen the sum of the line totals abovel - Tar Amount (o) of the above) - Freicht is the Shiplase + StupRate * 5ubtotal : 0.01 - Totaidoe is the sum of the theres above Add a new Person: - Ist, insert a new Builinessentity record. The only field you need to include is the Modified Date held. The others will be populated automatically. - Second, add a person - Use the BuninessEntityID recond you created in previous step. - Person Type is 't - Use your name for First, Middie, and Last. - Skip any field not needed. Add an address for your new personc - 1st, insert the Address Line 1, City, StateProvincelD lyou need to look this value uph, and Postal Code for your favorite physical store. - Add the address you fust created to the Businessentityaddress and tie it to the user you previously created. Add an order: - OrderDate is today - DueDate is 1 weck in the future - Status is 1 - Bal To Address and Ship To Address are both the address added above. - Ship Method is 'CARGO TRANSPORT 5' Add the foliowing items to the order above usine Special Offer ib of 1 : - 3 x Water Eattle - 30 ot. (WB-H098) - 1 Cable Lock 1LO-C100) - 2 Men's 5oorts Sharte, M iSH.M897.MI - 4 Longislecve Logo Jersey, M (LL-0192-M) - 'Uhe the tht Price from the product to populate the ListPrice held and alsa caleulate the LineTotal ficid. Update the order to indude- - Subtotal lealeulated froen the sum of the line totals abovel - Tar Amount (o) of the above) - Freicht is the Shiplase + StupRate * 5ubtotal : 0.01 - Totaidoe is the sum of the theres above