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

Author: Google for Developers - Bewertung: 1x - Views:46

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