alter table gas.user5 modify state varchar(40) not null; alter table gas.user3 add constraint unique_name unique(name); alter table gas.user3 drop index unique_name ...
#Get the Names of Employees Who Work in the Same Department as 'John Doe'. SELECT firstname,lastname,DEPARTMENT FROM Employee WHERE DEPARTMENT=(SELECT DEPARTMENT from employee WHERE FirstName = 'John' ...