why does this query run and return the wrong result? Go!

Here’s a sequel SQL dev challenge that trips up a lot of experienced developers. We’re comparing a player’s score to their team’s average score. There’s one important detail: the teams table does not have a score column. Many developers expect this query to fail with a “column not found” error. It doesn’t. It runs, and produces an incorrect result instead. Why does the database allow this? Subscribe to Google for Developers → https://goo.gle/developers Speakers: Jasmyne Roberts