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

SELECT MIN(year) FROM vehicletype;

SELECT MAX(year) FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(YEAR) FROM vehicletype;

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

SELECT MIN(year) FROM vehicletype;

Reason: 2009 is the smallest integer value in the year column .
MIN() function returns the smallest value of the specified column and here "year" is specified column for MIN function.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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