1 In MS SQL we can calculate the email address for our vendor contacts IF the vendor has their email domain value provided in the VendorUpdates_20230107 table (not all of them do!). Email addresses can be calculated using the contact's last name (up to 7 characters), the initial of the contact's first name (i.e., the first character of the first name), and Vendor's domain name. See sample output below. Using a single SQL statement, update all of the contact email addresses in the Vendors_copy table where an email address can successfully be determined (i.e., where there is an email domain for the vendor in the Vendors_copy table). How to create and use a single View in my update statement? Could I also use a Common Table Expression in my update statement