human
Schema:
regions (REGION_ID, REGION_NAME)
countries (COUNTRY_ID, COUNTRY_NAME, REGION_ID)
departments (DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION_ID)
jobs (JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
employees (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
job_history (EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
locations (LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY, STATE_PROVINCE, COUNTRY_ID)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the job ID for those jobs which average salary is above 8000.
assistant
SELECT job_id FROM employees GROUP BY job_id HAVING AVG(salary) > 8000
human
Can you return all detailed info of jobs which was done by any of the employees who is presently earning a salary on and above 12000?
assistant
SELECT * FROM job_history AS T1 JOIN employees AS T2 ON T1.employee_id = T2.employee_id WHERE T2.salary >= 12000
human
what is the phone number of employees whose salary is in the range of 8000 and 12000?
assistant
SELECT phone_number FROM employees WHERE salary BETWEEN 8000 AND 12000
human
What is the full name ( first name and last name ) for those employees who gets more salary than the employee whose id is 163?
assistant
SELECT first_name , last_name FROM employees WHERE salary > (SELECT salary FROM employees WHERE employee_id = 163 )
human
What are the full name (first and last name) and salary for all employees who does not have any value for commission?
assistant
SELECT first_name , last_name , salary FROM employees WHERE commission_pct = 'null'
human
What are the full names and salaries for any employees earning less than 6000?
assistant
SELECT first_name , last_name , salary FROM employees WHERE salary < 6000 ;