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

hamza

Save to bookmark

2022-05-18

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

Sample table:emp_department

DPT_CODE DPT_NAME        DPT_ALLOTMENT
-------- --------------- -------------
      57 IT                      65000
      63 Finance                 15000
      47 HR                     240000
      27 RD                      55000
      89 QC                      75000

 EMP_IDNO EMP_FNAME       EMP_LNAME         EMP_DEPT
--------- --------------- --------------- ----------
   127323 Michale         Robbin                  57
   526689 Carlos          Snares                  63
   843795 Enric           Dosio                   57
   328717 Jhon            Snares                  63
   444527 Joseph          Dosni                   47
   659831 Zanifer         Emily                   47
   847674 Kuleswar        Sitaraman               57
   748681 Henrey          Gabriel                 47
   555935 Alex            Manuel                  57
   539569 George          Mardy                   27
   733843 Mario           Saule                   63
   631548 Alan            Snappy                  27
   839139 Maria           Foster                  57

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

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

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

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

All Answers

Similar questions

need a help?

find thousands of online teachers now