Google Sheets =Query() Group By and Order By

A short video that shows you how to use Group By and Order By in your Queries.
-- Affiliate Links --
If you would like to create KZbin Videos I highly recommend using TubeBuddy www.tubebuddy....

[@r.j.slagter3112]

Great explanation and good value! Thanks a bunch mate : )

[@davindersingh8986]

REALLY A NICE VIDEO

[@gentilgarcon9847]

Nice video. Thank you

[@stlouisphotography]

Good job. I'd like to learn more about how to break out of the select string, come back into it, syntax issues, etc. For example, I get an error with this - =query({Eddie!$A1:$H25}, "select sum(Col2) where " & roundup(month( & "Col1" & )/3,0) & " = " & C$6 & " label sum(Col2) '' ", 0). I think my problem is I'm trying to pull Col1 into the month function. I already broke out of the string with the roundup function, but then I need to somehow come back in to reference Col 1 of my range. The roundup and month function together wouldn't work unless I broke out of the string.

[@greggreyes6869]

what if there are entries like montana, michigan, etc but their countries are Canada in column I, how can i filter those not "United States" thanks