Who is the employee with the highest salary? Specify his/her full name.
the highest salary refers to MAX(salary); full name = firstname, lastname
SELECT firstname, lastname FROM employee WHERE CAST(REPLACE(SUBSTR(salary, 4), ',', '') AS REAL) = ( SELECT MAX(CAST(REPLACE(SUBSTR(salary, 4), ',', '') AS REAL)) FROM employee )