Question 7 (0.5 points) This table has been created (Database Schema) and popula

Question

Question 7 (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 being displayed?

Question 7 options:

SELECT MIN(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(inventoryonhand) FROM vehicletype;

Save

Question 8 (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 23 being displayed?

Question 8 options:

SELECT SUM(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;

SELECT SUM(inventoryonhand) FROM typeofvehicle;

Save

Question 9 (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 2009 being displayed?

Question 9 options:

SELECT MIN(year) FROM vehicletype;

SELECT MAX(year) FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(YEAR) FROM vehicletype;

Save

Question 10 (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);
and populated with at least 25 rows,
which of the following is a valid aggregate function:

Question 10 options:

SELECT * FROM vehicletype;

SELECT typeofvehicle FROM vehicletype ORDER BY manufacturer;

SELECT SUM inventoryonhand FROM vehicletype;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;

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

Explanation / Answer

Question 7

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

Answer: SELECT AVG(inventoryonhand) FROM vehicletype;

Question 8

Which of the following commands would result in a value of 23 being displayed?

Answer: SELECT MAX(inventoryonhand) FROM vehicletype;

Question 9

Which of the following commands would result in a value of 2009 being displayed?

Answer:SELECT MIN(year) FROM vehicletype;

Question 10

which of the following is a valid aggregate function:

Answer:SELECT MIN(year) FROM vehicletype;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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