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;          -- 同順位の場合、ITEM_CODEで昇順