Which of the following is a valid aggregate function: Question 10 options: SELEC

Question

Which of the following is a valid aggregate function:

Question 10 options:

SELECT * FROM vehicletype ORDER BY manufacturer;

SELECT typeofvehicle FROM vehicletype ORDER BY year;

SELECT SUM (inventoryonhand) FROM manufacturer;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;

SELECT * FROM vehicletype ORDER BY manufacturer;

SELECT typeofvehicle FROM vehicletype ORDER BY year;

SELECT SUM (inventoryonhand) FROM manufacturer;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;

Explanation / Answer

Ans)SELECT MIN(year) FROM vehicletype;

We have to apply Aggregate function on the nummeric data column in the table.So that the aggregate function will summarize the column data and return the result.

Here as the table info is not provided.According to the options I understood that year is the numeric type column and vehicletype is the table name.

________________

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.