SQL Queries

select emp_no,hire_date as to_date

from employees

union

select emp_no,to_date

from dept_emp;

select emp_no,hire_date as to_date

from employees

union all

select emp_no,to_date

from dept_emp;

select emp_no,hire_date as to_date

from employees

intersect

select emp_no,to_date

from dept_emp;

select emp_no,hire_date as to_date

from employees

except

select emp_no,to_date

from dept_emp;

select * from salaries;

select * from titles;

select emp_no,title

from titles

where title='Engineer';

select * from employees;

select emp_no,to_date

from titles

intersect

select emp_no,to_date

from salaries;

select emp_no,to_date

from titles

intersect

select emp_no,to_date

from salaries

where to_date>'1990-1-01';

select emp_no,to_date

from titles

intersect

select emp_no,to_date

from salaries

where to_date>'1990-1-01'

limit 10;

select emp_no,to_date

from titles

intersect

select emp_no,to_date

from salaries

where to_date in('1990-1-01','1993-02-12');