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" with the criteria that the column named "FirstName" is "Peter" and the column named "LastName" is "Jackson"?Select one:a.SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'b.SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'c.All of the answers are correctd.SELECT FirstName='Peter', LastName='Jackson' FROM Persons

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"?

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

With SQL, how do you select a column named "FirstName" from a table named "Persons"?Select one:a.SELECT Persons.FirstNameb.SELECT FirstName FROM Personsc.EXTRACT FirstName FROM Personsd.SELECT FirstName.TableName FROM Personse.None of the answers are correct

Which SQL query retrieves all rows where the 'name' column does not start with the letter 'A'?