Question
From the following tables write a SQL query (using define stored procedures) to find the departments with budgets more than Rs. 70000 and display
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
Step by Step Solution
3.32 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
To write a SQL query using stored procedures to find the departments with budgets more than Rs 70000 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Concepts of Database Management
Authors: Philip J. Pratt, Mary Z. Last
8th edition
1285427106, 978-1285427102
Students also viewed these Programming questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App