ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

The Query needs to have the distinct clause in the select statement
and the UPPER clause in the order by clause.

eg.
select distinct id, type from user_list order by UPPER(type)

Please let me know if there is any solution to this issue
thanks in advance.
--
Best,
Gourish Singbal