Monthly Report Generation

Base on daily records to generate monthly report:

 

Example:

select to_char(price_date,'yyyy-mm') Price_date,              

       avg(price) price

  from dm_data_1

 group by to_char(price_date,'yyyy-mm')