From the following tables write a SQL to display the first name and last name of each employee,

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.

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

SELECT emp_details.emp_fname AS "First Name", emp_lname AS "Last Name", emp_department.dpt_name AS "Department", dpt_allotment AS "Amount Allotted" FROM emp_details INNER JOIN emp_department ON emp_details.emp_dept = emp_department.dpt_code;

First Name Last Name Department Amount Allotted Alan Snappy RD 55000 Maria Foster IT 65000 Michale Robbin IT 65000 Carlos Snares Finance 15000 Enric Dosio IT 65000 Jhon Snares Finance 15000 Joseph Dosni HR 240000 Zanifer Emily HR 240000 Kuleswar Sitaraman IT 65000 Henrey Gabriel HR 240000 Alex Manuel IT 65000 George Mardy RD 55000 Mario Saule Finance 15000

From the following tables write a SQL to display the first name and last name of each employee,

All Answers

Similar questions

need a help?

find thousands of online teachers now