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_det

You have a database with a customers table. Here is a partial listing of the records:First_NameLast_NameMichelleSenseAlexisRodriguezFloraSatoYou also have a table of employees. Here is a partial listing of the records:First_NameLast_NameSamuelClementineAlexisRodriguezJabariReddyYou want to create a query that will not return “Alexis Rodriguez” as part of the results. You begin typing your query:SELECT First_Name, Last_Name FROM customers________SELECT First_Name, Last_Name FROM employeesWhat should you type in the blank space between the two queries? (Please type your answer all in upper case. Example: SELECT)

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.

Question 1You want to select author's last name from a table, but you only remember the author’s last name starts with the letter B, which string pattern can you use? 1 pointSELECT lastname from author where lastname like ‘B#’ SELECT lastname from author where lastname like ‘B%’ SELECT lastname from author where lastname like ‘B$’ None of the above

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?