#IT-6202
Awesome StudentQuestion • Database Management System 1 (Oracle)
Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESWhat query should be used in order todisplay the firstname and length of firstname rename the column length of firstname as Number of Character of all employees whose salary is between 4400 and 8300
Answer
SELECT FIRSTNAME, LENGTH(FIRSTNAME) AS "NUMBER OF CHARACTER"FROM EMPLOYEESWHERE SALARY BETWEEN 4400 AND 8300;