Display the first name of all employees.
select first_name from employees
Show the first name of all employees and their salary.
select first_name, salary from employees
Show the first name of all employees and their salary for employees whose first name does not contain the letter M.
select first_name, salary from employees where first_name not like '%m%'
Show the first name of all employees and list their salary in descending order for employees whose first name does not contain the letter M.
select first_name, salary from employees where first_name not like '%m%' order by salary desc
Out of these employees what is the phone number for the employee with the highest salary.
select phone_number from employees where first_name not like '%m%' order by salary desc limit 1
What is the email for the employee whose first name does not contain the letter M with the highest salary.
select email from employees where first_name not like '%m%' order by salary desc limit 1