Question 8 (0.5 points)

Assuming that a table has been correctly constructed with the command CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT, year INTEGER, inventoryonhand INTEGER); and populated with at least 25 rows, which of the following is NOT a valid aggregate function:

Question 8 options:

SELECT MIN(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT SUM(inventoryonhand) FROM vehicletype;

Question 9 (0.5 points)

If this command correctly enters a row of data into a table, which of the following would be the correct command to create that table? INSERT INTO vehicletype VALUES (1, truck, Chevrolet);

Question 9 options:

CREATE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

Question 10 (0.5 points)

(True/False). Will this SQL statement create a table called vehicletype?

CREATE TABLE vehicletype (carid PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

Question 10 options:

	True
	False