Which employees do not have the letter M in their first names?
select * from employees where first_name not like '%m%'
What were their full names, hire dates, salaries, and department numbers?
select first_name, last_name, hire_date, salary, department_id from employees where first_name not like '%m%'
Order these by ascending department number.
select first_name, last_name, hire_date, salary, department_id from employees where first_name not like '%m%' order by department_id