MMORPG Game Character Outfit Advisor

Problem Statement

Problem Description An MMORPG game is under development. You need to write a query for the profile and inventory mechanics that advises players on the best quality items currently available in their inventory for each item type. Item quality is represented by three ranks, ordered from lowest to highest: common , rare , and epic . For each account and each item type they possess, determine the highest available quality, and provide a formatted list of all items the player owns that match this highest quality. Schema accounts table: +----------+--------------+------------------+ | column | type | description | +----------+--------------+------------------+ | id | INT | Primary Key | | username | VARCHAR(255) | Account username | +----------+--------------+------------------+ items table: +--------+---------------------------------+-----------------+ | column | type | description | +--------+---------------------------------+-----------------+ | id | INT | Primary Key | | type | ENUM('swo