As a result of a squeeze on profits from lower production and higher costs, state revenue from oil and gas has fallen 24% from a year earlier