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

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