List employees’ first and last names

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.  List employees’ first and last names.

2. Give all information on employees in manufacturing system.

3.  Just give employee names in manufacturing systems.

Answer 1

1.   SELECT FirstName, LastName from EMPL;

2.  SELECT * from EMPL WHERE Workdept = “Menufacture”;

3.  Just give employee names in manufacturing systems.