Evaluate these two SQL statements:1. SELECT CONCAT(first_name, last_name),LENGTH(CONCAT(first_name, last_name))FROM employeeWHERE UPPER(last_name) LIKE '%J'OR UPPER(last_name) LIKE '%K'OR UPPER(last_name) LIKE '%L';2. SELECT INITCAP(first_name) || INITCAP(last_name),LENGTH(last_name) + LENGTH(first_name)FROM employeeWHERE INITCAP(SUBSTR(last_name, 1, 1)) IN ('J', 'K', 'L');How will the results differ?Select one:a.Statement 2 will execute, but statement 1 will not.b.Statement 1 will execute, but statement 2 will not.c.The statements will retrieve different data from the database.d.The statements will retrieve the same data from the database, but will display it differently.

You are given a table Employee which has the following columns :id, FirstName, LastName.You have to use a query to display all those employees whose first names start with the letter ‘R’ and end with the letter ‘I’. Some queries are given below -(a) SELECT * FROM Employee WHERE FirstName LIKE '%RI%';(b) SELECT * FROM Employee WHERE FirstName LIKE 'R%' AND FirstName LIKE '%I';(c) SELECT * FROM Employee WHERE FirstName LIKE 'R' AND 'I';(d) SELECT * FROM Employee WHERE FirstName LIKE 'R%I';Choose the most appropriate option from below :Options: Pick one correct answer from belowOnly (c)Only (b)(b) and (d)(b), (c) and (d)(a) and (c)None of the above

From the given table "emp_det" which has column values "emp_id", "fist_name", "last_name", "email","person_id", "dept_id", "salary". Write a SQL query to retrieve the employee ID, first name, and last name of employees whose first names contain the letter 'S' and who work in departments where at least one employee's first name contains the letter 'S'.Table Name: emp_detInput format :The input records are already prepopulated as per the given requirement.Output format :The result of the query is a list of employee details, including their employee ID, first name, and last name as shown below.emp_id first_name last_name123 S Arvind124 Sj Kumar234 Sk Seema256 Sd venkatRefer to the sample output for the column headers.

Which SQL statement will list the employee details inside the EMPLOYEE table order by last names in ascending order, if two employees have same last name order them by the employee first name in ascending order?Select one:a.​SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE     FROM EMPLOYEE          ORDER BY  EMP_LNAME ASC, EMP_FNAME DESC;​b.​SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE     FROM EMPLOYEE          LIST BY  EMP_FNAME, EMP_LNAME;​c.​SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE     FROM EMPLOYEE          ORDER BY  EMP_LNAME, EMP_FNAME;​d.​SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE     FROM EMPLOYEE          ORDER BY  EMP_FNAME, EMP_LNAME;

Question 2A DEPARTMENTS table contains DEP_NAME, and DEPT_ID_DEP columns and an EMPLOYEES table contains columns called F_NAME and DEP_ID. We want to retrieve the Department Name for each Employee. Which of the following queries will correctly accomplish this?1 pointSELECT D.F_NAME, E.DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE D.DEPT_ID_DEP = E.DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE E.DEPT_ID_DEP = D.DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES, DEPARTMENTS WHERE DEPT_ID_DEP = DEP_IDSELECT E.F_NAME, D.DEP_NAME FROM EMPLOYEES, DEPARTMENTS

Which of the following query is correct to fetch all the employee details from the employee tableselect * from employee;extract name from employee;