Delete Records from a Table Based on Count and Latest Record

How to Delete from a Table Using Columns with Null Values in Snowflake