I have given employees table as
SQL> desc employees
Name Null? Type
----------------------------------------- -------- ----------------
EMPLOYEE_ID NOT NULL NUMBER(6)
FIRST_NAME VARCHAR2(20)
LAST_NAME NOT NULL VARCHAR2(25)
EMAIL NOT NULL VARCHAR2(25)
PHONE_NUMBER VARCHAR2(20)
HIRE_DATE NOT NULL DATE
JOB_ID NOT NULL VARCHAR2(10)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2)
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
The question is
Create a query that displays the first eight characters of employees '
last name and indicates the amounts of the salaries with asterisks.
Each asterisk signifies a thousand dollars .sort the data
in desending order of salary . Label the column as Employees and Their salaries
Employees and Their salaries
King ******************
Kochchar *********************************
De Haan *************************
Thank you.