SQLite Exercise: Get the maximum salary of an employee working as a Programmer

Write a query to get the maximum salary of an employee working as a Programmer.

Sample table: employees

SQLite Code:

SELECT MAX(salary) 
FROM employees 
WHERE job_id = 'IT_PROG';

Output:

MAX(salary)
-----------
9000

Relational Algebra Expression:

Relational Algebra Tree:

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 minimum salary from employees table.
Next: Write a query to get the average salary and number of employees working the department 90.