CREATE VIEW vwTopStackedItems
    AS
        SELECT TOP 20 MAX(inventorySlot.quantity) AS 'Top Stacked', item.itemName AS 'Item Name'
        FROM inventorySlot
        JOIN item
        ON inventorySlot.itemID = item.itemID
        JOIN character
        ON inventorySlot.characterID = character.characterID
        WHERE quantity > 1
        GROUP BY itemName
        ORDER BY MAX(quantity) DESC
    GO


SELECT * FROM vwTopStackedItems
GO