From the following tables write a SQL query (using define stored procedures) to find the departments...

Transcribed Image Text:

From the following tables write a SQL query (using define stored procedures) to find the departments with budgets more than Rs. 70000 and display the first name and last name of employees. Table:Employee EMP_ID 1 2 3 4 Table: Department DPT_CODE 57 63 47 27 F_NAME Ahmed Sara Daoud Johen DPT_NAME IT Finance HR RD L_NAME Adam Carlos Deen Mike DEPT 57 63 DPT_Budget 65000 15000 240000 55000 57 63 From the following tables write a SQL query (using define stored procedures) to find the departments with budgets more than Rs. 70000 and display the first name and last name of employees. Table:Employee EMP_ID 1 2 3 4 Table: Department DPT_CODE 57 63 47 27 F_NAME Ahmed Sara Daoud Johen DPT_NAME IT Finance HR RD L_NAME Adam Carlos Deen Mike DEPT 57 63 DPT_Budget 65000 15000 240000 55000 57 63

Answer rating: 100% (QA)

The question asks to write an SQL stored procedure that will find employees who work in departments ... View the full answer