This is part 3 of a 4-part series on some of my most valued SQL ‘hacks’. Check out the others in the series: JOINs aren’t anyone’s favorite part of SQL. They aren’t as flashy as window functions or…

Towards Data Science is a community-powered publication that showcases work in data science, machine learning and artificial intelligence. Every day newcomers, seasoned researchers and industry practitioners publish tutorials, research notes and real-world case studies that help the field move forward.

Towards Data Science

Inner JOIN is a way to join two tables based on some time logic. Range JOINs are a more refined way to merge two tables together. Lateral joins allow you to access columns after the FROM statement. BigQuery uses implicit Lateral Joins via a UNNEST tool.

Take your SQL from Good to Great: Part 3

<p>Sql execution order, which is excellent for sql tuning</p>
