I want to find the results of this query by using a custom question. I don’t want to use a native query. can someone tell me the steps that I need to take in order to achieve this.
SELECT to_char(Date, ‘YYYY-MM’) as Month, sum(order_value)/count(distinct(Order_Number)) as avg_order_ value FROM mainorders
group by to_char(Date, ‘YYYY-MM’)
order by to_char(Date, ‘YYYY-MM’);