Question 6.6.( TCO 1) Given Professors table with LastName, FirstName, and MI fields, which of the following would select all fields from the table?( Points: 5)
SELECT * FROM Professors; SELECT * Professors; SELECT Last Name, First Name, MI FROM Professors; SELECT * ALL
Question 7.7.( TCO 1) Which of the following would extract all rows containing the numbers 10 or 20?( Points: 5)
WHERE number BETWEEN 10 and 20 WHERE number = 10 or number = 20 WHERE number = ' 10 or 20 ' Where number = ' 10 ' or ' 20 '
Question 8.8.( TCO 3) Which of the following statements would extract the average price of all the products?
Assume you have a table with the following columns:( Points: 5)
SELECT ProductID, Avg( UnitPrice)