Solved programming problem

Show the total no of jobs within 0k to 10k, 10k to 20k and so on salary ranges(max_salary-min_salary) groups from the jobs table

Source code

SELECT COUNT(*)

FROM jobs

GROUP BY (MAX_SALARY-MIN_SALARY) DIV 10000;
Join the discussion

Add your comment