query: SELECT employee_id ,  first_name ,  last_name ,  salary FROM employees WHERE salary  >  ( SELECT AVG (salary) FROM employees ) AND department_id IN ( SELECT department_id FROM employees WHERE first_name LIKE '%J%')
question: display that employee number, name( first name and last name ), and salary all employee who earn more that average salary and who work department any employee 'J' their first name.
query_toks: SELECT employee_id , first_name , last_name , salary FROM employees WHERE salary > ( SELECT AVG ( salary ) FROM employees ) AND department_id IN ( SELECT department_id FROM employees WHERE first_name LIKE ' % J % ' )
query_toks_no_value: select employee_id , first_name , last_name , salary from employees where salary > ( select avg ( salary ) from employees ) and department_id in ( select department_id from employees where first_name like value )
question_toks: display that employee number, name( first name and last name ), and salary all employee who earn more that average salary and who work department any employee 'J' their first name.