From the following tables write a SQL query (using define stored procedures) to find the departments...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these programming questions
-
"Fortran, Algol and Lisp invented most programming language concepts 50 years ago; adding the concept of object-orientation suffices to explain all programming languages to date". To what extent is...
-
1- Retrieve the department ID, department name, location ID, and city for each department from the HR schema. Hint: use natural join 2-...
-
Danbury Inc is a resident Canadian corporation with worldwide operations. Canadian operations resulted in taxable income of $ 1 . 1 0 million and non - Canadian operations resulted in taxable income...
-
The figure below shows the flow of a car wash process that has three stations; vacuum, wash, and dry. The numbers in parentheses are the times in minutes for each step of the process. Answer parts a,...
-
An Object is placed against the center of a thin lens and then moved away from it along the central axis as the image distance i is measured Figure gives i versus object distance p out to ps = 60cm,...
-
Is the collision in Example 10.7 elastic? Data from Example 10.7 Pucks 1 and 2 slide on ice and collide. The inertia of puck 2 is twice that of puck 1 . Puck 1 initially moves at \(1.8 \mathrm{~m} /...
-
My Web Wholesalers, a small company in Maine, used the Internet to do business around the country. It made offers on its Web site but did not distribute e-mails to customers who did not request...
-
1 What is HRM 2 What is Training and Developmnt 3 What is Recruitment 4 What is Selection 5 What is HRP 6 What is Job Analysis 7 What is a Career Planning and Development 8 What is Job-Description 9...
-
You work for a large investment management firm. The analysts with your firm have made the following forecasts for the returns of stock A and stock B: VERY VERY WEAK VERY WEAK WEAK AVERAGE STRONG...
-
Let \(Y\) be normally distributed with mean \(=120\) and variance \({ }^{2}=64\). (a) Find \(P\left(\begin{array}{ll}Y & 130\end{array} ight)\). (b) Find \(P\left(\begin{array}{ll}Y & 135\end{array}...
-
There are two events \(A\) and \(B . P(A)=4\) and \(P(B)=4 . P\left(\begin{array}{ll}A & B\end{array} ight)=\) 24 . (a) Are \(A\) and \(B\) independent events? Explain why or why not. (b) Find...
-
Derive an expression for the law of corresponding states for a gas represented by the following expression: \[p=\frac{\Re T}{v-b}-\frac{a}{T v^{2}}\] \[\left[p_{\mathrm{R}}=\frac{8 T_{\mathrm{R}}}{3...
-
Let \(Z\) have the standard normal distribution. (a) Find \(P\left(\begin{array}{lll}0 & Z & 152\end{array} ight)\). (b) Find \(P\left(\begin{array}{ll}Z & 211\end{array} ight)\). (c) Find...
-
Two fair dice, one red and one green, are rolled. Let the event \(A\) be the sum of the faces showing is an even number. Let the event \(B\) be the sum of the faces showing is divisible by 3 . (a)...
-
If lim,+00 an 70 or lim,,00 a, does not exist, then En-1 an diverges. 00 Select one: O True O False
-
Suppose the spot and six-month forward rates on the Norwegian krone are Kr 5.78 and Kr 5.86, respectively. The annual risk-free rate in the United States is 3.8 percent, and the annual risk-free rate...
-
What are the characteristics of OLTP systems?
-
What is meant by concurrent update?
-
What additional factors must you consider during the information-level design of a distributed database?
-
Why is it difficult to convict organized crime leaders?
-
How would an audit not catch missing cash amounts of this magnitude?
-
While Al Capone was clearly the leader of his organization and benefited extensively, what enticed others to participate in his illegal activities?
Study smarter with the SolutionInn App