I need to write a sql query where I count number of employees who are not featured. Each employee can have multiple records with member comments. If they are featured then the feature date will have date otherwise will have null value. I want to ignore those who are have been featured atleast once (will have a date associated in the feature date column)

For example:

```
Empid   comment     featuredate
101      cool       null
101      bad        2/2/2020
102      nice       null
102      not nice   null

```

so my query should return only empid 102 as they are not featured atleast once.

What I tried?

I tried group by along with having, but stuck there.