GROUP BYHAVINGWHERE but different. (Why?)WHERE when you can. (Why?)SELECT sum(1) as N FROM flights WHERE dest = 'BDL';SELECT dest, sum(1) as N FROM flights GROUP BY dest HAVING dest = 'BDL';COUNT, SUM, MIN, MAX, AVGarray_agg, DISTINCT