This video demonstrates how to use Google Sheet's QUERY Function - SELECT, WHERE, LIKE, GROUP BY, PIVOT

The video well tell you the following:
How to select which columns you want to include in your query
How to perform calculations on columns - SUM, COUNT
How to specify OR and AND criteria for records to return with your query
How to specify date criteria
How to specify partial critria eg begins with
How to group by unique values within a specified column whilst performing calculations on other columns
How to pivot column headings with your query
------------------------