I have a table and I am only interested in two columns to perform two actions (Ignore or Good), and based on actions I need to keep only “Good” rows. I have tried several SQL windows functions but not able to achieve what I am looking for.