ttrU7eti

1CREATE TABLE IF NOT EXISTS `like` (
2 `liking_user_id` int(6) unsigned NOT NULL,
3 `liked_user_id` int(6) unsigned NOT NULL,
4 `like_time` timestamp NOT NULL,
5) 
6     
7date(like_time) as Date               count(liking_user_id ...) as Count
8
94/7/2019                                      85
10
114/8/2019                                      70
12
134/9/2019                                      85