SELECT
    e.first_name AS "employee",
    j.job_title AS "Job",
    d.department_name AS "dep name",
    e.salary AS "salary",
    gr.JOB_TITLE AS "Grade"
FROM employees e, departments d, jobs j, jobs gr
WHERE e.commission_pct IS NOT NULL AND e.department_id=d.department_id AND e.job_id=j.job_id AND e.salary BETWEEN gr.MIN_SALARY AND gr.MAX_SALARY