I'm not sure what is happening in my Google Sheet query and could really use some help. I have [a quick screencast](https://youtu.be/UyxDe4bdSHM) that demonstrates and explains the issue. 

Basically, I'm using a query to pull data from a Google Spreadsheet that is populated by a Google Form. If the form submits only numbers (100), there is no problem. However, if someone submits a string ($100 or 100 dollars), the query will not display the string. It will only display form submissions that are 100% numbers. 

Also, if the 1st submission is a string (not 100% numbers) the query will work. 

Here is my query

```
=query(data!B2:CL,"select B, C, D, E, F, G, H, I, J, CI, BZ, CA, BA  where J = 'Industry Certification'",false)

```

Any ideas on why this is happening?

Also, I'm aware that I can limit the form to numbers only. I'm trying to avoid that and learn 'why' this is happening.