#Alter Column Name in a table
Alter table Collection RENAME COLUMN RECEIVE_AMT to CURRENT_DUE;
select * from Collection;

#Modify data contents with a condition
Update Emp set commission = "100" where Emp_ID = "12";
Update Emp set commission = "100" where Emp_ID = "13";
SELECT a.Emp_ID, Emp_Name, commission, Department, b.SALE_AMT, c.PAYMENT_AMT, c.OUTSTANDING_AMT 
FROM Emp a LEFT OUTER JOIN Sales b ON b.Emp_ID = a.Emp_ID 
LEFT OUTER JOIN Collection c ON c.Emp_ID = a.Emp_ID GROUP By a.Emp_ID order by Department;



#Delete data for Emp_ID 27 from Emp dataset
Delete FROM Emp WHERE Emp_ID = "27";
select * from Emp order by Department;