SELECT MAX( x.rank ) AS rank
FROM (

SELECT id, cityAb, offPPG, @rownum := @rownum +1 AS rank
FROM team_stats t
JOIN (

SELECT @rownum :=0
)r
ORDER BY t.offPPG DESC
)x
WHERE x.cityAb =  'Jax'