Question

2x12=24
12
Consider the following "employee" table and write the output of the following SQL
queries
comm
ename
empno
8369
sal
800.00
mgr
8902
Job
CLERK
SALESMAN
SMITH
NULL
hiredate
1990-12-18
1991-02-20
1600.00
8698
8499
300.00
ANYA
1250.00
SETH
8698
1991-02-22
8521
8566
SALESMAN
MANAGER
500.00
NULL
MAHADEVAN
8839
1991-04-02
2985.00
T
MOMIN
8654
8698
1991-09-28
SALESMAN
MANAGER
1400.00
NULL
1250.00
2850.00
2450.00
8698
8839
1991-05-01
BINA
8882
SHIVANSH
MANAGER
8839
NULL
1991-06-09
k K
NULL
1992-12-09
8888
SCOTT
no
3000.00
5000.00
8566
NULL
8839
NULL
ANALYST
PRESIDENT
SALESMAN
AMIR
1991-11-18
8844
KULDEEP
8698
1991-09-08
1500 00
0.00
car
a. Write a query to display EName and Sal of employees whose salary are greater than or
cqual to 22002
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?
h. Write a query to display details of employs with the text "Not given", if commission is null?
1. Display the Distinct Designation (job) in the Organisation.
j. Display the Names of employees who are working as Manager or Analyst.
k. Delete all the record from the table club
re
DD
usic
ara
ts​

Answer 1

Answer:

this is not a definitely and able to question