I am a new user for NewRelic, now I can develop NRQL to query some data:

SELECT count(http.server.request.duration) FROM Metric WHERE stage = 'production' and url.full = '/AAAAAAA/BBBBBBBB' and http.request.method = 'GET' FACET http.response.status_code

and can get the pie graph below:

In fact, I hope to trigger a alert when 200 status rate < 95%
Could somebody know how to amend above NRQL to caculate 200 status rate?

Thanks

I have made some test to amend this QL but failed.