This table has been created (Database Schema) and populated with values listed i

Question

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 7 options:

SELECT SUM(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;

SELECT SUM(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

23 is the highest value in the column inventoryonhand and the name of the table is vehicletype .

MAX function returns the maximum value in the column.

So the Query is

SELECT MAX(inventoryonhand) FROM vehicletype;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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