@panosm
At @talent we use Postgres.
In my new blog post, I explain how I query a "daily_stats" table.
- "with" and "CTE"
- "window functions"
- "lateral" sub-queries
- "generate_series"
Many things to learn or refresh your memory about.
https://mirror.xyz/dashboard/edit/CxkN4TvWZBXmbUf7repP3LZMTXcaaVLtNwLNpKVxtik