Question

2) Write a query to display empno, ename, sal in the decreasing order of salary
3) Write a query to display the records of those employees who are earning commission more than their
salary
4) List the details of those Employees whose names are having A at any position
5) List the details of those Employees whose names does not contains B in it
6) List the details of those Employees whose names contains T at third position
7) List the details of those Employees whose names are starting with A ending with A and Starting with B
8) List the details of all the Employees whose commission = null
9) List the details of all the Employees who are working either in deptno=10 or working as clerk
10) List the details of all the Employees who are working as salesman and getting the salary >=500
11) List the details of all the Employees whose annual salary is in between 5000 – 15000
12) Write a query to display the employee name, job , salary, 15% bonus, and new salary ( salary+ bonus)

Answer 1

Explanation:

Photosynthesis is the process by which plants use sunlight, water, and carbon dioxide to create oxygen and energy in the form of sugar.