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 FS42 and item PF19, because the category for both items is FSH.) Order the output by category.
--Task # 12SELECT CATEGORY, ITEM_ID, DESCRIPTIONFROM ITEMWHERE EXISTS (SELECT COUNT(*) FROM ITEM IWHERE I._____________ = ITEM._______________GROUP BY CATEGORYHAVING ___________________)ORDER BY ________________;
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here