Which of the statements below best describes the result set returned by this SELECT statement? SELECT VendorID,       SUM(InvoiceTotal – PaymentTotal – CreditTotal) AS SumBalanceFROM InvoicesWHERE InvoiceTotal – PaymentTotal – CreditTotal > 0GROUP BY VendorID;

Which of the following SQL statements correctly retrieves the columns in the order: VendorFirstName, VendorLastName, and VendorName from the Vendors table, and sorts the results first by VendorLastName and then by VendorFirstName in Acending Order? A. SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorFirstName, VendorLastName;B.SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorLastName, VendorFirstName;C.SELECT VendorName, VendorFirstName, VendorLastName FROM Vendors ORDER BY VendorLastName, VendorFirstName;D. SELECT VendorFirstName, VendorLastName, VendorName FROM Vendors ORDER BY VendorFirstName DESC, VendorLastName DESC;

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

35. Egg fertilization usually occurs in the 

29. The prostate gland

37. The corpus luteum is composed of 

27. The adrenal gland is located near the

14. An adenoma is a

45. What is goiter? What is the most common cause of goiter worldwide? Explain. (2 pt)