Show each employees email, hire_date in 1st Aug, 87 05:10 PM format

SELECT EMAIL,DATE_FORMAT(HIRE_DATE,"%D %b, %y %h:%i %p")

FROM employees;