Task $12$: List the item ID$,$ description, and category for each pair of items that are in the same category. $($For example, one such pair would be item FS$42$ and item PF$19,$ because the category for both items is FSH$.)$ Order the output by category.

Code I input:

SELECT F$.$CATEGORY, F$.$ITEM$\_$ID$,$ F$.$DESCRIPTION

FROM ITEM F$,$ ITEM S

WHERE F$.$CATEGORY $=$ S$.$CATEGORY

AND F$.$ITEM$\_$ID $<>$ S$.$ITEM$\_$ID

AND S$.$CATEGORY IN $(\text{'}$BRD$\text{'},$ 'CAT', $\text{'}$FSH$\text{'})$

ORDER BY F$.$CATEGORY;

Test Feedback I recieved:

Status: FAILED!

Check: $1$

Test: $**$Task $12$:$**$ List the item ID$,$ description, and category for each pair of items that are in the same category

Reason: Expected:

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

$|$ CATEGORY $|$ ITEM$\_$ID $|$ DESCRIPTION $|$

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

$|$ BRD $|$ BC$33|$ Feathers Bird Cage $(12$x$24$x$18)|$

$|$ BRD $|$ KH$81|$ Wild Bird Food $(25$ lb$)|$

$|$ CAT $|$ CA$75|$ Enclosed Cat Litter Station $|$

$|$ CAT $|$ SP$91|$ Small Pet Carrier $|$

$|$ FSH $|$ FS$42|$ Aquarium $(55$ Gallon$)|$

$|$ FSH $|$ PF$19|$ Pump & Filter Kit $|$

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

Found:

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

$|$ CATEGORY $|$ ITEM$\_$ID $|$ DESCRIPTION $|$

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

$|$ BRD $|$ KH$81|$ Wild Bird Food $(25$ lb$)|$

$|$ BRD $|$ BC$33|$ Feathers Bird Cage $(12$x$24$x$18)|$

$|$ CAT $|$ SP$91|$ Small Pet Carrier $|$

$|$ CAT $|$ CA$75|$ Enclosed Cat Litter Station $|$

$|$ FSH $|$ PF$19|$ Pump & Filter Kit $|$

$|$ FSH $|$ FS$42|$ Aquarium $(55$ Gallon$)|$

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

Error : AssertionError $-$

Timestamp: $2024-02-2619$:$12$:$42\mathrm{.}674146$

$----------$

Can you please show me where I went wrong?