Google Sheets QUERY vs SQL: what’s the difference?
Excerpted from the advanced Google Sheets course, Data Analysis the Lazy Way.
If you’re used to writing SQL queries, it can be off-putting at first to work with Google Sheets queries (and vice-versa).
Let’s walk through a number of ways in which they’re similar & different, and how you can adapt each of them in your work.
Basic querying
Doing math on columns
Date comparison
Fuzzy phrase matching
Joining tables
Matching from a list of options
For more background on all of the QUERY syntax covered in this video, grab a copy of my Google Sheets formula cheat sheet at: https://trello.com/c/b2q3P0E3/39-10-k...