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
Structure of '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?
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
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