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

• SELECT FIRSTNAME, LENGTH(FIRSTNAME) AS NUMBER OF CHARACTERFROM EMPLOYEESWHERE SALARY BETWEEN 4400 AND 8300;
• SELECT FIRSTNAME, LENGTH(FIRSTNAME) AS "NUMBER OF CHARACTER"FROM EMPLOYEESWHERE SALARY BETWEEN 8300 AND 4400;
• SELECT FIRSTNAME, LENGTH(FIRSTNAME) AS "NUMBER OF CHARACTER"FROM EMPLOYEESWHERE SALARY BETWEEN 4400 AND 8300; Correct
• SELECT FIRSTNAME, INSTR(FIRSTNAME) AS "NUMBER OF CHARACTER"FROM EMPLOYEESWHERE SALARY BETWEEN 4400 AND 8300;