I have a table like this:
And I want to get something like:
fecha siguiendo seguidores 2016-01-02 430 1430 2016-01-03 450 NULL 2016-01-04 NULL 5000
I have two types of data
siguiendo. I want a column for each of them.
I have tried to emulate a FULL JOIN on the same table but I didn't get the expected result. Any ideas?