SQL Queries

select * from dept_manager;

select count(emp_no) as count_emp_no

from dept_manager

where dept_no='d001';

select count(emp_no) as count_emp_no

from dept_manager

where dept_no in('d001','d002');

select count(emp_no) as count_emp_no

from dept_manager

where to_date='1991-10-01';

select count(emp_no) as count_emp_no

from dept_manager

where to_date>'1991-10-01';

select dept_no,count(emp_no) as count_emp_no

from dept_manager

where to_date>'1991-10-01'

group by dept_no;