Show me the full name for the employees that get more salary then employee 163?
SELECT first_name ,  last_name FROM employees WHERE salary  >   ( SELECT salary FROM employees WHERE employee_id  =  163  ) 
full name = concatenation of first_name and last_name; more salary than employee 163 refers to comparison with a subquery SELECT salary FROM employees WHERE employee_id = 163;