Task $20$: List every column in the ITEM table and its associated data type.

My Answer:

SELECT COLUMN$\_$NAME, DATA$\_$TYPE FROM

INFORMATION$\_$SCHEMA.COLUMNS WHERE

TABLE$\_$NAME $=$ 'ITEM';

Result:

Status: FAILED!

Check: $1$

Test: $**$Task $20$:$**$ List every column in the $`$ITEM$`$ table and its associated data type

Reason: Expected:

$+-------------+---------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+-------------+---------------+------+-----+---------+-------+$

$|$ ITEM$\_$ID $|$ char$(4)|$ NO $|$ PRI $|$ NULL $||$

$|$ DESCRIPTION $|$ varchar$(30)|$ YES $||$ NULL $||$

$|$ ON$\_$HAND $|$ decimal$(10,0)|$ YES $||$ NULL $||$

$|$ CATEGORY $|$ char$(3)|$ YES $|$ MUL $|$ NULL $||$

$|$ LOCATION $|$ char$(1)|$ YES $||$ NULL $||$

$|$ PRICE $|$ decimal$(7,2)|$ YES $||$ NULL $||$

$+-------------+---------------+------+-----+---------+-------+$

Found:

$+-------------+-----------+$

$|$ COLUMN$\_$NAME $|$ DATA$\_$TYPE $|$

$+-------------+-----------+$

$|$ ITEM$\_$ID $|$ char $|$

$|$ DESCRIPTION $|$ varchar $|$

$|$ ON$\_$HAND $|$ decimal $|$

$|$ CATEGORY $|$ char $|$

$|$ LOCATION $|$ char $|$

$|$ PRICE $|$ decimal $|$

$+-------------+-----------+$

Error : AssertionError $-$

Timestamp: $2024-03-1817$:$34$:$03\mathrm{.}420467$