oracle group by having code example

Example: oracle group

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name;