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 employee last name, work department and monthly salary for those in Services, Planning and Information center departments.
2. List employee last name, work department, department number, and department name.
3. Which employees earn more than their manager ?
4. List suppliers who supply only red parts.