w3resource

SQLite Exercise: Find the names, the salary of the employees whose salary is equal to the minimum salary for their job grade

Write a query to find the names (first_name, last_name), the salary of the employees whose salary is equal to the minimum salary for their job grade.

Sample table : employees


Sample table : jobs


SQLite Code:

SELECT first_name, last_name, salary 
FROM employees 
WHERE employees.salary = 
(SELECT min_salary FROM jobs WHERE employees.job_id = jobs.job_id);

Output:

first_name  last_name   salary
----------  ----------  ----------
Karen       Colmenares  2500
Martha      Sullivan    2500
Randall     Perkins     2500

Practice SQLite Online


Model Database

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query to find the names (first_name, last_name), the salary of the employees whose salary is greater than the average salary.
Next: Write a query to find the names (first_name, last_name), the salary of the employees who earn more than the average salary and who works in any of the IT departments.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook