Add SQL query examples - Githubissues

ndjenkins85 / ndj_cookie

My personal python project quick start. Useful to jump into projects with favourite tooling, and to record best practices

https://www.ndjenkins.com

MIT License

1 stars 0 forks source link

Open ndjenkins85 opened 2 years ago

ndjenkins85 commented 2 years ago

Should include examples of;

[x] subqueries, with
[ ] group by and aggregates
[ ] case, when, then, end
[ ] create, insert
[ ] joins (all types)
[x] rank, row_number, dense_rank analytical / window functions https://www.toptal.com/sql/intro-to-sql-windows-functions
[ ] datediff
[ ] between for shortened window functions
[ ] union, union all
[x] distinct, deduplication
[x] random sampling
[ ] t-test
[ ] chi squared test

ndjenkins85 commented 2 years ago

Other advanced functions not covered