Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From the following tables write a SQL query (using define stored procedures) to find the departments with budgets more than Rs. 70000 and display

image

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Programming questions

Question

What are the characteristics of OLTP systems?

Answered: 1 week ago

Question

What is meant by concurrent update?

Answered: 1 week ago