The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types ...

You can use the IMPORTRANGE function in Google Sheets to easily copy data from one spreadsheet to another.

First, you need to identify the Google Sheet document from which you want to embed data from in another sheet, and grab the url.