Which employee has the highest salary? Please give his or her full name.
the highest salary refers to MAX(salary); full name = firstname, lastname
SELECT firstname, lastname FROM employee ORDER BY salary DESC LIMIT 1
database name:db_id human_resources
location table location Cols: location id dtype integer, location city dtype text, address dtype text, state dtype text, zip code dtype integer, office phone dtype text, 
position table position Cols: position id dtype integer, position title dtype text, education required dtype text, minimum salary dtype text, maximum salary dtype text, 
employee table employee Cols: social security number dtype text, last name dtype text, first name dtype text, hire date dtype text, salary dtype text, gender dtype text, performance dtype text, position id dtype integer, location id dtype integer, 
