instruction: Group and count the job id for all employees whose salary is smaller than any salary of those employees whose job title is MK_MAN for visualizing a bar chart, and could you rank by the y axis in ascending please?
response: SELECT JOB_ID, COUNT(JOB_ID) FROM employees WHERE SALARY < (SELECT MIN(SALARY) FROM employees WHERE JOB_ID = 'MK_MAN') GROUP BY JOB_ID ORDER BY COUNT(JOB_ID)