Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a Table Empl to store employee details as shown below and write statements for following queries based on the table. ename empno 8369

Create a Table Empl to store employee details as shown below and write statements for following queries based

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?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To perform the requested queries on the Empl table you can use SQL statements as follows a Write a q... 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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Databases questions

Question

1.11 Identify the major psychological models of abnormal behavior.

Answered: 1 week ago

Question

How Do We Define Abnormal Behavior?

Answered: 1 week ago