SQL Exercises: Find the first name and last name of employees working for departments with a budget more than Rs. 50000

SQL JOINS: Exercise-28 with Solution

From the following tables write a SQL query to find the departments with budgets more than Rs. 50000 and display the first name and last name of employees.

Sample table:emp_department

Sample table: emp_details

Sample Solution:

SELECT emp_details.emp_fname AS "First Name", emp_lname AS "Last Name"
  FROM emp_details 
    INNER JOIN emp_department
        ON emp_details.emp_dept = emp_department.dpt_code
    AND emp_department.dpt_allotment > 50000;

Output of the Query:

First Name	Last Name
Alan		Snappy
Maria		Foster
Michale		Robbin
Enric		Dosio
Joseph		Dosni
Zanifer		Emily
Kuleswar	Sitaraman
Henrey		Gabriel
Alex		Manuel
George		Mardy

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following tables write a SQL to display the first name and last name of each employee, along with the name and sanction amount for their department.
Next: From the following tables write a SQL query to find the names of departments where more than two employees are working. Return dpt_name.