Write a SELECT statement that returns one column from the Ve…

Write a SELECT statement that returns one column from the Vendors table named VendorFullName. Create this column from the VendorFirstName and VendorLastName columns. Format it as follows: vendor last name, comma, vendor first name (for example, “Doe, John”). Filter for contacts whose vendor last name begins with the letter A, B, C, or E (not D). A.SELECT VendorLastName + ‘, ‘ + VendorFirstName AS VendorFullNameFROM VendorsWHERE VendorLastName = ‘A’, ‘B’, ‘C’, ‘E’; B.SELECT VendorLastName + ‘, ‘ + VendorFirstName AS VendorFullNameFROM VendorsWHERE VendorLastName IN ‘%’; C.SELECT VendorLastName + ‘, ‘ + VendorFirstName AS VendorFullNameFROM VendorsWHERE VendorLastName LIKE ‘%’;

Due to hunting, the population of Northern elephant seals wa…

Due to hunting, the population of Northern elephant seals was reduced to 20 individuals at the end of the 19th century. Since then, their population has since rebounded to over 30,000. What is the most likely long-term effect of hunting on the elephant seal population?