Where clause It's a row operation method, It cannot hold agg functions, Group by comes after where clause Having clause It is a column operator, It holds agg functions, It's is placed after group by clause