Write one DDL statement to add a new column AssignDate of date type in ProjAssignment table, which should allow no null values. Because there are already existing rows in the table which have no AssignDate data, your DDL statement must define a default value using current date in this column. When this DDL statement is executed, it will then update the AssignDate of every existing row with the default current date.