SQL Server

I have no idea where to even begin...

You have been asked to create a trigger that will log to an alert table when your quantity on hand for any product is down to 1.

Create the following:

1. Script to create the alert table. (It needs to have at least a datetime stamp, alert type, alert description).

2. Script to create the trigger for where you keep track of inventory.