Question $3$

CITY data type

CustID

Cust Type

City

PostalCode

SalesOrderNum

ProductID

OrderQty

LineTotal

ProductName

ProductLine

ProductListPrice

$697$

S

Tooele

$84074$

SO$50270$

$863$

$44$

$639\mathrm{.}3717$

Full$-$Finger Gloves, L

M

$37\mathrm{.}99$

$146$

L

Seattle

$98104$

SO$67266$

$869$

$41$

$1097\mathrm{.}6182$

Women's Mountain Shorts, L

A

$69\mathrm{.}99$

$697$

S

Tooele

$84074$

SO$51783$

$867$

$40$

$1259\mathrm{.}82$

Women's Mountain Shorts, S

A

$69\mathrm{.}99$

$546$

L

Loveland

$80537$

SO$57186$

$869$

$40$

$1259\mathrm{.}82$

Women's Mountain Shorts, L

A

$69\mathrm{.}99$

$546$

L

Loveland

$80537$

SO$48089$

$863$

$39$

$666\mathrm{.}7245$

Full$-$Finger Gloves, L

M

$37\mathrm{.}99$

$146$

L

Seattle

$98104$

SO$67266$

$867$

$38$

$1196\mathrm{.}829$

Women's Mountain Shorts, S

A

$69\mathrm{.}99$

$697$

S

Tooele

$84074$

SO$51783$

$869$

$36$

$1133\mathrm{.}838$

Women's Mountain Shorts, L

A

$69\mathrm{.}99$

$302$

S

Offenbach

$63009$

SO$51109$

$864$

$36$

$1028\mathrm{.}7$

Classic Vest, S

S

$63\mathrm{.}5$

$125$

S

Stamford

$06901$

SO$46610$

$863$

$35$

$598\mathrm{.}3425$

Full$-$Finger Gloves, L

M

$37\mathrm{.}99$

$315$

S

Merritt Island

$32952$

SO$46673$

$863$

$35$

$598\mathrm{.}3425$

Full$-$Finger Gloves, L

M

$37\mathrm{.}99$

City is the city of shipping address for the order, and is always required for each order. Shortest city is $5$ letters and longest is $15.$

Which ONE of the following is the most appropriate data type to use for City $?$

varchar$(15)$

char

varchar

varchar$(5-$to$-15)$

char$(15)$