I have the following code: select pil_pilotname, pil_flight_pay from pilots group by pil_pilotname, pil_flight_pay having pil_flight_pay > 2586.67 / I wanted to use avg(pil_flight_pay) instead of 2586.67. SQL, however, does not allow. I'm trying to get the flight pays that exceed the average flight pay for all pilots. What should I modify? Thanks.