SQL Exercise (Simple Joins)

1. Display employee number, employee name, department name, location from employee and department tables.

2. Display employee number, employee name, salary + comm as TOTAL, location from employee and department tables.

3. Display employee name, location from employee and department tables.

4. Diplay employee name, department name, job from employee and department tables who job is CLERK.

5. Display employee name, deptno, dname from employee and department table where location is DALLAS.

6. Display employee number, name, address and city from employee, employee address tables.

7. Display employee nmae, address from employee and employee address tables who lives in zip code 75039

8. Display employee name, department name, location who were getting comm as null.

9. Display first 3 characters of employee name, job, sal, comm, location from employee and department tables who works in department 20 or 30, salary should be more than 1000 comm as not null.

10. Display location, department name, length of location, length of department name for employee numbers 1001, 1008, 1009.