SQL Queries

select * from salaries;

select emp_no,salary

from salaries;

select emp_no,salary

from salaries

where salary>=50000;

select emp_no,salary

from salaries

where salary<=50000;

select emp_no,salary

from salaries

where salary<50000 and salary>40000;

select emp_no

from salaries

where to_date>'1970-01-01' and to_date<'2000-01-01';

select * from titles;

select title,count(emp_no) as count_emp_no

from titles

group by title;

select title,count(emp_no) as count_emp_no

from titles

where to_date<'2000-01-01'

group by title;

select title,count(emp_no) as count_emp_no

from titles

where to_date='9999-01-01'

group by title;