Where Query

I use this:

[gdoc key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/htmlview” query=”select A , B where C contains ‘PhD Completed’ “]

And where clause is working but the problem is the first student row (Oluwafemi Ajayi (Glasgow) ) is displaying in the header.

Try freezing your Sheet’s header row.

I would like to return values where E is not 0 or ‘Total’
this does not work “select A,B,C,D,E where E != 0 or ‘Total'”
Also
the labels for the columns within the shoot are only showing up in column A,B

here is the sheet I’m working with
[gdoc key= https://docs.google.com/spreadsheets/d/1Qu1cURdERVYsWVwW9Xb2VsT-MO2-WPZ0-yp3_cARZxI/edit?usp=sharing query=”select A,B,C,D,E where E != 0 ]