Alter Tables

Hi! 1. You have a table customers with a column email that currently allows NULL values. Modify the table so that future entries must always have an email. ALTER TABLE customers ALTER COLUMN email SET NOT NULL; here the alter is used to set the column email that should not be blank. 2. In the users table, ensure that the username column is unique across all records using an ALTER statement. ALTER TABLE users ADD CONSTRAINT unique_username UNIQUE (username); here an new contraint unique_name is u