1. Give employee names outside manufacturing systems.

Question

Give the following relations

EMPL ( FirstName, LastName, Workdept, Empno, Educlevel, Jobcode, Salary, Bonus, hiredate)

Dept (Deptno, Deptname, Mgrno, Adurdept)

Statement for creating above table :

1. Give employee names outside manufacturing systems.

2. List employee names and their departments for employee numbers between 100 and 300

3. List employee numbers, names and educational levels for three educational 16, 18, and 20. 

Answer 1

1.  SELECT FirstName from EMPL WHERE Workdept NOT IN (‘Menufacture’);

2. SELECT EmpName, DeptName from EMPL WHERE Empno BETWEEN 100 and 300;

3. SELECT Empno, FirstName, Educlevel from EMPL WHERE Educlevel IN (16, 18, 20);