Create a Table Empl to store employee details as shown below and write statements for following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a Table Empl to store employee details as shown below and write statements for following queries based on the table. ename empno 8369 SMITH 8499 ANYA 8521 SETH 8566 8654 MOMIN 8698 BINA 8882 8888 SCOTT 8839 AMIR 8844 KULDEEP MAHADEVAN SHIVANSH job hiredate sal 1990-12-18 800.00 SALESMAN 1600.00 8698 1991-02-20 SALESMAN 8698 1991-02-22 1250.00 MANAGER 8839 1991-04-02 SALESMAN 8698 1991-09-28 MANAGER 8839 1991-05-01 MANAGER 8839 1991-06-09 ANALYST 8566 1992-12-09 1991-11-18 PRESIDENT NULL SALESMAN 8698 CLERK mgr 8902 3000.00 5000.00 comm deptno NULL 20 300.00 500.00 2985.00 NULL 1250.00 1400.00 2850.00 2450.00 1991-09-08 1500.00 30 30 20 30 NULL 30 NULL 10 NULL 20 NULL 10 30 0.00 1. Consider the Empl table and write SQL command to get the following. a. Write a query to display EName and Sal of employees whose salary are greater than or equal to 2200? b. Write a query to display details of employs who are not getting commission? c. Write a query to display employee name and salary of those employees who don't have their salary in range of 2500 to 4000? d. Write a query to display the name, job title and salary of employees who don't have manager? e. Write a query to display the name of employee whose name contains "A" as third alphabet? f. Write a query to display the name of employee whose name contains "T" as last alphabet? g. Write a query to display the name of employee whose name contains "M" as First and "L" as third alphabet? Page 4 Q h. Write a query to display details of employs with the text "Not given" if commission is null? Create a Table Empl to store employee details as shown below and write statements for following queries based on the table. ename empno 8369 SMITH 8499 ANYA 8521 SETH 8566 8654 MOMIN 8698 BINA 8882 8888 SCOTT 8839 AMIR 8844 KULDEEP MAHADEVAN SHIVANSH job hiredate sal 1990-12-18 800.00 SALESMAN 1600.00 8698 1991-02-20 SALESMAN 8698 1991-02-22 1250.00 MANAGER 8839 1991-04-02 SALESMAN 8698 1991-09-28 MANAGER 8839 1991-05-01 MANAGER 8839 1991-06-09 ANALYST 8566 1992-12-09 1991-11-18 PRESIDENT NULL SALESMAN 8698 CLERK mgr 8902 3000.00 5000.00 comm deptno NULL 20 300.00 500.00 2985.00 NULL 1250.00 1400.00 2850.00 2450.00 1991-09-08 1500.00 30 30 20 30 NULL 30 NULL 10 NULL 20 NULL 10 30 0.00 1. Consider the Empl table and write SQL command to get the following. a. Write a query to display EName and Sal of employees whose salary are greater than or equal to 2200? b. Write a query to display details of employs who are not getting commission? c. Write a query to display employee name and salary of those employees who don't have their salary in range of 2500 to 4000? d. Write a query to display the name, job title and salary of employees who don't have manager? e. Write a query to display the name of employee whose name contains "A" as third alphabet? f. Write a query to display the name of employee whose name contains "T" as last alphabet? g. Write a query to display the name of employee whose name contains "M" as First and "L" as third alphabet? Page 4 Q h. Write a query to display details of employs with the text "Not given" if commission is null?
Expert Answer:
Answer rating: 100% (QA)
To perform the requested queries on the Empl table you can use SQL statements as follows a Write a q... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
How would you define behavioral learning? Explain How would you define cognitive learning? Explain Also List an example for both.
-
Simmel argued a century ago that the pace of life had quickened inexorably: the populace of the metropolis was constantly searching out new entertainments and distractions, but satisfaction was only...
-
Use the table below to find: (fog)(-10) = (fof) (11) = X -10 f(x) -1 g(x) 4 -1 -7 -4 -7 11 (gof)(-4)= (gog)(7) = 4 7 15 4 7 -4 11 -4 15 7 -1 15 -10 -7 -10 11
-
Last year, Lena biked 330 miles. This year, she biked k miles. Using k, write an expression for the total number of miles she biked.
-
The required force to be exerted at A by lever ABC is 3.6 lb. Knowing that the stretched spring exerts a 12-lb force at C, determine (a) The value of α, (b) The reaction at B. 0.9 in. B -1.4 in...
-
A virtual machine is generated from a physical server by which method in a P2V migration?
-
For each of the following sets of numbers, calculate the sample size \((N)\), the mean \(\mathrm{X}^{-}\) , the standard deviation \((s)\), and the standard error of the mean \(s \mathrm{X}^{-}\): a....
-
I don't see that in my intermediate accounting text I saved from college, you explain to another member of the accounting division of Dowell Chemical Corporation. This will take some research. Your...
-
Consider the following graph and the heuristic values of each state. The start state is S and the only goal state is G. B E S A Heuristic BCD E G 6 0 6 4 1 10 0 a) What path would uniform cost graph...
-
Franchise taxes are levied on businesses that gain a franchise right of doing business in a jurisdictions territory. The data in Table 9.1 are franchise tax revenues in the city of Sunbelt, Florida,...
-
What is the regionalization / localization strategy? How does it differ from globalization?
-
What do you mean by techniques of auditing? Discuss the various techniques adopted by an auditor in the course of his audit work.
-
What is audit working paper? What are its objectives? Discuss the essential characteristics of a good working paper. Who can claim the ownership of those papers?
-
What is internal control questionnaire?
-
Describe the steps to be followed in reviewing computer installation.
-
What is statutory audit? Describe the points of differences between statutory audit and nonstatutory audit.
-
Explain Database System Architecture.
-
A statistical study shows that the fraction of television sets of a certain brand that are still in service after x years is given by f (x) = e-0.15x. (a) What fraction of the sets are still in...
-
Teresa is a civil engineer who uses her automobile for business. Teresa drove her automobile a total of 21,732 miles during 2012, of which 95 percent was business mileage. The actual cost of...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19-year-old nanny $125 per week for 48 weeks during the current year. a. What is the employer's portion...
-
Jason and Mary Wells, friends of yours, were married on December 30, 2012. They know you are studying taxes and have come to you with a question concerning their filing status. Jason and Mary would...
-
A fertilizer producing company purchases nitrates, phosphates, potash, and an inert chalk base and produces four different fertilizers A, B,C, and D. The cost of these nitrates, phosphates, potash,...
-
We are interested to produce $P$ in the reaction $A ightarrow P$ using a continuous reactor at $v=240$ liters/ hr with $C_{A_{0}}=3$ moles/liter. However, it is noticed that there is a second...
-
Heavy fuel oil, initially semisolid at $15^{\circ} \mathrm{C}$ is to be heated and pumped through a $15 \mathrm{~cm}$ diameter (inside) pipe at the rate of $20000 \mathrm{~kg} / \mathrm{h}$. The pipe...
Study smarter with the SolutionInn App