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:
![Create a Table Empl to store employee details as shown below and write statements for following queries based](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/650a8f8732323_1695190916874.jpg)
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.
-
Repeat the previous problem calculating prices for American options instead of European. What happens? In previous problem a. What is the price of a European call option with a strike of $95? b. What...
-
The robot arm shown in Fig. 9.74 places packages on a conveyor belt. What is the distance x? Fig. 9.74 2.50 m 102.0 X 1.75 m Belt
-
Give a list of undistributed operating expenses as per USHA.
-
Cartwell Inc. makes picture frames which are sold in a local retail store and through various websites. Wood for frames .......................................................... $10,000 Rent for...
-
Below is select information from DC United Company's income statement. At the end of the current year, the weighted average number of common shares outstanding was 141,500. Income Statement, End of...
-
Background: A new ownership group has recently purchased ABC Liquors. You have been hired by the new management team to analyze their sales data for the past year and provide them with insights about...
-
On 31 December 20X4 Hugh Ltd gained control of Jackman Ltd by acquiring 80% of its shares for $250,000. At this date, Jackman had share capital of $200,000 and retained profits of $45,000. Below is...
-
Q10: Region ( experienced compressive stresses and has a than the rest of the bracket. Region ( ) experienced tension stresses and has a of the bracket. Deep Drawing and Stretch Forming width (into...
-
A sample of 1500 computer chips revealed that 32% of the chips do not fail in the first 1000 hours of their use. The company\'s promotional literature claimed that above 29% do not fail in the first...
-
The 75 lb block is released from rest 5 ft above the plate. Determine the compression of each spring when the block momentarily comes to rest after striking the plate. Neglect the mass of the plate....
-
Indiana Soy Products (OSP) buys soybeans and processes them into other soy products. Each ton of soybeans that OSP purchases for $250 can be converted for an additional $180 into 675 lbs of soy meal...
-
The 2025 Annual Report of Splish International contains the following informatio (in millions) June 29, 2025 June 27, 2024 Total assets $1,545 $1,502 Total liabilities 989 1,060 Net sales 2,800 2.971...
-
The statement of income and unclassified statement of financial position for Sandhill Inc. follow: \ table [ [ \ table [ [ Sandhill Inc. ] , [ Statement of Financial Position ] , [ March 3 1 ] ] , ]...
-
If the joint cost function for two products is C(x, y) = xy2 + 1 dollars (a) Find the marginal cost (function) with respect to x. (b) Find the marginal cost with respect to y.
-
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...
-
Preparation of a statement of financial position and statement of profit or loss and other comprehensive income LO3, 4 The summarised general ledger trial balance of Ryan Ltd, a spare parts...
-
Preparation of a statement of financial position, statement of profit or loss and other comprehensive income and statement of changes in equity LO3, 4, 5 The summarised general ledger trial...
-
Preparation of a statement of financial position, statement of profit or loss and other comprehensive income and statement of changes in equity LO3, 4, 5 The summarised general ledger trial...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App