Delete rows based on a condition of another column

here is an image of it

SQL SERVER delete rows based on a condition of another column

here is an image of itI am trying to work in SQL server just its easier to show it in excel.