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