Displays the last names of employees under the manager id 124 or 12 Also generate an email add from getting the first 4 letters of first name of each employee.

Example: rico@apple.com

I used this solution in chug and keep shows the results error please help

SELECT FIRST_NAME ||' '||LAST_NAME AS FULL_NAME, SALARY, MANAGER_ID

FROM employees;

WHERE MANAGER_ID IS 124 OR 122;