New table with distinct ID + calculated columns on multiple conditions

Hello

I have a table with all my orders, linked to customers with a date and a channel

Here's a sample

I'd like to create a new table that calculate number of orders per year per customer for a specific channel.

Let's take the example of channel G, I'd like to create the following table

N = Number of orders in the last 365 days of the customer for the channel G

N+1 = Number of orders between 366 and 730 days compare to today of the customer for the channel G

I guess it is not that complicated as it seems something classical to do, but I don't find the right way to do it.

Thanks for your help

Maxime