SQL is a great language for analysing and slicing and dicing data. The folks at Google who build Google Sheets appreciate this too. So much so that they have built the ability to use SQL right into Google Sheets spreadsheet app.
Below are some introductory guides to using the SQL funtionality within Google Sheets.
- https://www.howtogeek.com/450465/how-to-use-the-query-function-in-google-sheets/
- https://support.google.com/docs/answer/3093343?hl=en
- https://docs.google.com/document/d/1BV94ZVI1b1AkM0xOx503mfo01Yj9CVtdFXdQZzelGNk/edit#heading=h.ypwityb6874c
- https://sheetsformarketers.com/google-sheets-formulas/query
Posted below as images or pdf just in case:
https://www.howtogeek.com/450465/how-to-use-the-query-function-in-google-sheets/
https://support.google.com/docs/answer/3093343?hl=en
https://sheetsformarketers.com/google-sheets-formulas/query
