6 a new table has been requested to support tracking automat

6 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: emaild (numeric), emaildate (datetime),customer#(numeric) Primary key: emailid column, define as an identity column add the following data rows and display resulting rows 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

Solution

CREATE TABLE email_log(emaild int NOT NULL PRIMARYKEY, emaildate datetime NOT NULL DEFAULT GETDATE(),customer# int)

INSERT INTO email_log(cutomer#) VALUES(1007)

INSERT INTO email_log(customer#) VALUES(1008)

INSERT INTO email_log (emailid) VALUES(25)(customer#) VALUES(1009)