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')

Comments