group by oracle code example

Example 1: oracle sql group by date year

Select count(1), country_of_sale, to_char(datefield, 'YYYY-MM') AS yyyymm
from table 
where country_of_sale IN ('USA', 'EUROPE', 'ASIA')
group by country_of_sale, to_char(datefield, 'YYYY-MM')
order by to_char(datefield, 'YYYY-MM');

Example 2: oracle group

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