Sample Header Ad - 728x90

How to use a WHERE clause with a GROUP BY

0 votes
2 answers
140 views
I'm learning SQL so apologies if this is too basic a question. I can't seem to figure out how to use a WHERE clause after I GROUP BY a field. enter image description here For example, how would I filter the results using a WHERE clause to only see those countries where the Order count is greater than 100? Thank you
Asked by Burner918 (3 rep)
Aug 31, 2023, 07:38 PM
Last activity: Aug 31, 2023, 10:04 PM