-- https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/COALESCE.html
SELECT product_id, list_price, min_price,
       COALESCE(0.9*list_price, min_price, 5) "Sale"
  FROM product_information
  WHERE supplier_id = 102050
  ORDER BY product_id;