https://www.youtube.com/watch?v=DX2ShzPccZk&feature=emb_title&ab_channel=Datagran
All your CSV and Google Sheets files come in text format. In order to get your data correctly you need to cast it.
Example: In your SQL query you can add
CAST(Revenue as FLOAT64) as myrevenue