My sample data fictitiously looks like this:
Incidence_ID, Order_ID, Order_Status
Each incidence will have more than one order_id, and each order_id has one status - either "completed" or "open"
I need to write a query to find out for each incidence_id if it is fully completed where each and all of its order_status is "complete". Anything less, the incidence_id is "open"
In the attached sample data, incidence A is complete and B and C are open.
84596-incidence-status.txt