repos_starred (view)
49 rows where "starred_at" is on date 2021-03-25
This data as json
created_at (date) 10 ✖
- 2017-10-23 30
- 2019-07-17 3
- 2019-07-20 3
- 2019-09-05 3
- 2020-03-21 3
- 2019-09-08 2
- 2019-10-07 2
- 2019-09-03 1
- 2019-10-13 1
- 2020-04-18 1
0 records
CREATE VIEW repos_starred AS select stars.starred_at, starring_user.login as starred_by, repos.* from repos join stars on repos.id = stars.repo join users as starring_user on stars.user = starring_user.id join users on repos.owner = users.id order by starred_at desc;