Question 3 (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 a valid aggregate function:

Question 3 options:

SELECT SUM inventoryonhand FROM vehicletype;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;

Question 4 (0.5 points)

This table has been created (Database Schema) and populated with values listed in RESULTS.

Database Schema

vehicletype 10 rows

Id (PK) INTEGER

typeofvehicle TEXT

manufacturer TEXT

year INTEGER

inventoryonhand INTEGER

RESULTS

Id	typeofvehicle	manufacturer	year	inventoryonhand
1	Pickup	Chevrolet	2009	12
2	SUV	Ford	2017	13
3	SUV	Toyota	2015	7
4	Sedan	Toyota	2014	8
5	Sedan	Ford	2017	10
6	Coupe	Hyundai	2010	8
7	Pickup	Honda	2015	7
8	Sedan	Honda	2017	23
9	SUV	Hyundai	2013	6
10	Pickup	Ford	2017	16

Which of the following commands would result in a value of 11 (eleven) being displayed?

Question 4 options:

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(inventoryonhand) FROM vehicletype;

Question 5 (0.5 points)

Which of the following commands contains an error?

Question 5 options:

	CREATE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT, year INTEGER);
	SELECT * FROM vehicletype;