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

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

With SQL, how do you select all the columns from a table named "Persons"?Select one:a.SELECT Personsb.SELECT [all] FROM Personsc.SELECT *.Personsd.None of the answers are correcte.SELECT * FROM Persons

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

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 can you return all the records from a table named "Persons" sorted descending by "FirstName"? SELECT * FROM Persons SORT BY 'FirstName' DESC SELECT * FROM Persons ORDER BY FirstName DESC SELECT * FROM Persons SORT 'FirstName' DESC SELECT * FROM Persons ORDER FirstName DESC