Wondering if anyone's run reports in Postgres for say:
+ Contributors with stories published in the last year
+ Contributors sorted by number of associated stories
… and so on? Specifically, I'm trying to remember the path through the tables from 'story' to 'person'.
Any tips welcome (and will be added to the Github wiki of useful SQL)!
Phillip.
--
Phillip Smith
http://phillipadsmith.com
+ Contributors with stories published in the last year
+ Contributors sorted by number of associated stories
… and so on? Specifically, I'm trying to remember the path through the tables from 'story' to 'person'.
Any tips welcome (and will be added to the Github wiki of useful SQL)!
Phillip.
--
Phillip Smith
http://phillipadsmith.com