Show the employee first name, last name, and education level for only those employees with an entered education level, but show all available education levels, so that your results are as in the following table. (Hint: only a single table select using employee; RIGHT JOIN with others; do not use WHERE.)

table name: employee :: Column names: ID, firstName,lastName, jobTitle, salary, notes PRIMARY KEY is ID

Table Name: education :: column names: ID, edname PRIMARY KEY Is ID

Table Name: employee_education :: column name: employeeID, educationID compound primary key from employeeID and educationID fk_Employee_EmployeeID indicating that employeeID is a foreign key for the ID field in table employee fk_Education_EducationID indicating that educationID is a foreign key for the ID field in table education

Need help with this MySQL query. Someone gave me a code it is not working.