How many employees first names contain the letter M?
select count ( * ) from employees where first_name like '%m%'
Yes.
select first_name, last_name from employees where first_name like '%m%'
How many employees first names do not contain the letter M?
select count ( * ) from employees where first_name not like '%m%'
What are their full names?
select first_name, last_name from employees where first_name not like '%m%'
When were they hired?
select hire_date from employees where first_name not like '%m%'