What set of Transact-SQL statements should you run?
Solution: You run the following Transact-SQL statement:…