Problem
I. Use the ALTER TABLE statement to add a new column to a table in our AdventureWorks2019 database. I encourage you to explain your choice and make comments about the output
II. I would like you to form a query to compute an average. Let us say that we want to see the average tax rate grouped by tax type in the Sales.SalesTaxRate table. Assume this is an assignment that needs to be completed in the workplace, and therefore requires you to inspect the database and in particular this table first.
III. Use the DATEDIFF function to calculate the difference between any two dates in the Production.ProductCostHistory table. In the output you want the product ID, today's date, end date, and elapsed days (or months). I would like you to explain the syntax of the query you are creating as well as the output. A similar exercise is solved in the book in Chapter X and was also done in class during Lecture X.