HELP TABLES;
HELP DESCRIBE EMPLOYEE;
HELP DESCRIBE DEPARTMENT;
HELP DESCRIBE PROJECT;
SELECT * FROM SALARY;
DELETE FROM SALARY;
SELECT * FROM PROJECT;
SELECT dname FROM DEPARTMENT;
SELECT pname,pnum FROM PROJECT;
HELP SELECT;
CREATE USER user10 User-A;
SELECT ssn,ename FROM EMPLOYEE;
SELECT * FROM PROJECT WHERE pnum=20;
SELECT ename,pname FROM EMPLOYEE,PROJECT;
SELECT snum FROM DEPARTMENT;
SELECT snum,dnum FROM DEPARTMENT;
SELECT * FROM PROJECT WHERE pnum=30 OR pname='Assistive Tech' OR pnum=1111;
SELECT pname FROM PROJECT WHERE pnum=150;
SELECT * FROM EMPLOYEE;
QUIT;
