1. Filtering out rows with NULL values only when a value already has a row with a NON NULL value

    Filtering out rows with NULL values only when a value already has a row with a NON NULL value