select a, b, cfrom table1group by group1 -- Doing the grouping first --having con1 -- In the group doing the conditional statement --