hello help please confused...

I have this query that suppose to pull out only the counts for the typei column, but when i run it, it pulls out the count for the entire database and doesnt obey the where clause rule...

```
SELECT [type], typei, vtdate, count (typei) as count
FROM vtindex
where typei is not null or typei <> '#'
and vtdate between '2016/06/01' and '2016/06/30'
GROUP BY
[type], Typei, vtdate
HAVING
COUNT(typei) > 1

```

The idea is that the user puts in a date spam, and gives them the counts of typei for that specific date spam

thanks...