specifying ORDER BY with a fixed order

[kmesser]

select producer, sum(t1rev) current_revenue , sum(t2rev) prior_revenue from (select t1.producer, sum(t1.revenue) t1rev, sum(0) t2rev from otest t1 where t1.tdate = '4-JAN-2000' group by t1.producer union select t2.producer, sum(0) t1rev, sum(t2.revenue) t2rev from otest t2 where t2.tdate = '3-JAN-2000' group by t2.producer) group by producer