search

gvwilson / sql-tutorial

The Querynomicon: An Introduction to SQL for Wary Data Scientists
https://gvwilson.github.io/sql-tutorial/
Other
418 stars 35 forks source link

feat: confusing aliases for table in comparison of individual and aggregate values #6

Closed gvwilson closed 5 months ago

gvwilson commented 5 months ago

In 043 ("compare individual values to aggregates within groups") the alias left that you give the penguins table is I think confusing. That's actually an inner join, isn't it? (interesting that that's legal in sqlite)

— Roy Pardee