Use SSMS to complete the following steps:

Step $1$: Create a new database and name it Inventory

Step $2$: Use SQL CODE to create the Tables listed in the Attached File $($Show me the tables in the left margin$)$

Step $3$: Create Database Diagram

Step $4$: Use SQL code to INSERT the data in each table $($Show me the top $1000$ rows in each table$)$

Step $5$: Create ONE QUERY to complete the following:

Step $6$: Use an SQL Built$-$in Aggregate Function to calculate the number of customers. Name the new Column CustomerNumber

Step $7$: Use an SQL Built$-$in Aggregate Function to calculate the total quantity in stock. Name the new Column TotalProduct

Step $8$: Use an SQL Built$-$in Aggregate Function to calculate the average size. Name the new Column AverageProductSize

Step $9$: Select All Columns from table Product and add a new column DollarValue that calculates the dollar value for each row$/$record in the inventory. This is the Formula for the new column: DollarValue $=$ QtyInStock $*$ Price