By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
user_id | channel_id |
---|---|
1 | 11 |
2 | 12 |
4 | 14 |
user_id | number_of_items | expiration |
---|---|---|
1 | 1 | 2021-08-06 18:50:23 |
1 | 2 | 2021-08-06 18:50:23 |
user_id | item_id |
---|---|
1 | 100 |
1 | 101 |
1 | 102 |
1 | 104 |
COUNT(*) |
---|
4 |
sum(number_of_items) |
---|
3 |