Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Nice job, this is a great way to teach something like SQL. Any plans to add more chapters? Would love to see something around window functions AND CTEs as this format would go a long way in showing when and how to use them.


Did you have a look at https://www.windowfunctions.com ? Their exercises were a great introduction for me.

I also discovered the ability to select from multiple tables and do joins using where clauses instead, which to me is a lot more intuitive than explicit/imperative join statements. I didn’t see anything covering queries like those (maybe because there’s only one table in the dataset, idk i’m on mobile).




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: