SELECT 
    ITEM.ITEM_POPULAR_RANK AS RANK,
    ITEM.ITEM_CODE AS CODE,
    ITEM.ITEM_NAME AS NAME
FROM ITEM
WHERE ITEM.SALE_END_DATE IS NULL
ORDER BY ITEM.ITEM_POPULAR_RANK, ITEM.ITEM_CODE;