SQL Queries

select * from titles;

select * from employees;

select emp_no,first_name

from employees

where emp_no in

(select emp_no

from titles);

select emp_no,first_name

from employees

where emp_no not in

(select emp_no

from titles);

select * from dept_emp;

select emp_no,first_name,last_name

from employees

where emp_no not in

(select emp_no

from dept_emp);

select * from dept_emp;

select emp_no,first_name,last_name

from employees

where emp_no  in

(select emp_no

from dept_emp);

select * from dept_manager;

select emp_no,dept_no

from dept_manager

where dept_no in 

(select dept_no

from dept_emp);