select pn,-avg(x_axis_angle),-avg(y_axis_angle) from zc
where time > now() - interval '90 days'
group by pn
order by pn ;
