repos_starred (view)
79 rows where forks_count = 5
This data as json
created_at (date) 2 ✖
- 2020-03-21 44
- 2020-10-11 35
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;