I have a small report I need to make which consists of a status and a destination. Basically, I have a status table with 5 status. I have a destination with two destinations. Then, I have the export table which includes a reference to a status and to a destination. I need to obtain a repartition table which will lay out something like this:

Destination           Pending              Retry
My destination 1         12                  4
My destination 2         13                  2

So, the goal is to obtain that in one SQL and also include all status even if there are zero count in it.