Hey everyone I have two tables with output like this:

Month\_Table

[![enter image description here](https://i.stack.imgur.com/kOInb.png)](https://i.stack.imgur.com/kOInb.png)

Transaction\_Table
[![enter image description here](https://i.stack.imgur.com/flIAQ.png)](https://i.stack.imgur.com/flIAQ.png)

I need to calculate the monthly revenue by channel and the previous month's revenue: I did this query but it is not completed

```
Select date_created, channel, sum(revenue) as monthly_revenue 
from transaction_table  
GROUP BY  date_created,channel

```

The result should be displaying monthly revenue and the month's revenue of previous month.

How can I do that?