I'm stuck on this problem any one know the answer.
**Write a query that displays the grade of all employees based on the value of the column JOB,
as per the table shown below. Order the result according to the grade! **
JOB GRADE
PRESIDENT A
MANAGER B
ANALYST C
SALESMAN D
CLERK E
None of them above O
This should be the output
JOB G
--------- -
PRESIDENT A
MANAGER B
MANAGER B
MANAGER B
ANALYST C
ANALYST C
SALESMAN D
etc.
The database I'm using is EMP and JOB is a column within EMP