If you’re using SQL some of the first things you probably learned about were joins and aggregate functions (such as COUNT and SUM). One thing that is not always taught is how these two concepts can interact, and sometimes produce incorrect results. In this video we’ll discuss the things to look out for, the concept of a “fanout”, and why it matters to SQL writers and Looker users alike.

Loading more stuff…

Hmm…it looks like things are taking a while to load. Try again?

Loading videos…