/*6. Write a query in SQL to display the full name (first and last), hire date, salary, and department number for those 
employees whose last name does not containing the letter M and make the result set in ascending order by department number.*/
SELECT first_name || ' ' || last_name as Full_Name, hire_date,    
 salary,  department_id  
  FROM employees  
   WHERE first_name NOT LIKE '%M%'  
     ORDER BY department_id;