Could you please display the first and last names of all employees whose first names end in the letter "m"?
select first_name, last_name from employees where first_name like '%m'
What are their hire dates?
select first_name ,hire_date from employees where first_name like '%m'
What commission pct do they get?
select commission_pct from employees where first_name like '%m'
What is the name of the person who gets the highest pct commission?
select first_name, last_name from employees order by commission_pct desc limit 1
What is the hire date of the person who gets the lowest pct commission?
select hire_date from employees order by commission_pct asc limit 1