SELECT 
    ITEM_POPULAR_RANK AS RANK, ITEM_CODE AS CODE, ITEM_NAME AS NAME, SALE_END_DATE FROM ITEM
    WHERE SALE_END_DATE >= CURRENT_TIMESTAMP  OR SALE_END_DATE IS NULL
    ORDER BY ITEM_POPULAR_RANK, ITEM_CODE