A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below.
 • Tablename: email_log
 • Columns: emailid (numeric), emaildate (datetime), customer# (numeric)
 • Primary key: emailid column, define as an Identity Column
 • Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected)

1. Emaildate = current date, customer# = 1007
 2. Emailid = specify to use the column default value, emaildate = current date, customer# = 1008
 3. Emailid = 25, emaildate = current date, customer# = 1009