SQL Queries

select * from employees;

select count(emp_no) as count_emp_no

from employees

where gender='F';

select emp_no,first_name

from employees

where gender='F' AND hire_date>='1990-01-01';

select emp_no,first_name,last_name

from employees

where gender='F';

select first_name

from employees

where first_name like 'P%';

select last_name

from employees

where last_name like 'Janan_';

select first_name

from employees

where first_name not like 'P%';

select last_name

from employees

where last_name like '%i';

select last_name

from employees

where last_name not like '%i';

select last_name

from employees

where last_name like '%__llo';

select distinct(last_name) as distinct_last_name

from employees

where last_name like '%__llo';