SQLite Exercise: Get the difference between the highest and lowest salaries

Write a query to get the difference between the highest and lowest salaries.

Sample table : employees

SQLite Code:

SELECT MAX(salary) - MIN(salary) DIFFERENCE
FROM employees;

Output:

DIFFERENCE
----------
21900

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to get the number of employees with the same job.
Next: Write a query to find the manager ID and the salary of the lowest-paid employee for that manager.