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
;