Query - Google Sheet - SQL

[WillSTARK]

Hi,

If anyone is familiar with SQL or Query (from Google) then one may be able to help me.

I have this Query (which works)=
QUERY(E12:G9620,"select count(G) where E = 'Engineering' and G like '%/%' or G <>''")

Yet when I add date conditions as below, it does not work and shows (#Values!):
=QUERY(E12:G9620,"select count(G) where E = 'Engineering' and G like '%/%' or G <>' and G > date '2016-10-15' and G < date '2017-01-15")

I may miss something in the syntax, yet being a beginner I do not see it. I broke it down but when I assemble pieces of the query it does not work.

Thanks in advance,

 

[J.Ty.]

Just first ideas (I do not have time to make tests) about your logical statement

E = 'Engineering' and G like '%/%' or G <>' and G > date '2016-10-15' and G < date '2017-01-15")

1. You should add parentheses to make sure how it is computed
2. Something is wrong with the ' signs, which delineate text strings.

J.Ty.