Hello, i have one table like that:
Date | USERS_ID |
| ID |
---|
2012-05-22 | 1 |
| 1 |
2012-05-22 | 2 |
| 2 |
2012-05-22 | 3 |
| 3 |
2012-05-22 | 4 |
| 4 |
2012-05-23 | 1 |
| 5 |
2012-05-23 | 3 |
| 6 |
2012-05-23 | 4 |
| 7 |
2012-05-24 | 1 |
| 8 |
2012-05-24 | 2 |
| 9 |
2012-05-24 | 3 |
| 10 |
I want to known how many users logged yeasterday but not logged today
for example
for 2012-05-23 [1 user, 25%]
for 2012-05-24 [1 user, 33.33%]