adding queries for oe analysis