can someone please help me with the below requirement?
I have a table with sample data below
Now, I want to write a query that 1. It don't miss any ID in the report 2. If a particular ID has a Completed status then that will be included and other rows for same ID will be excluded 3. If no completed status then one Row with Faulted status will be included.
so below should be in my report