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

266
Следующее
Популярные
37 дней – 2 2193:45
Mo’s Story: Starting Families
Опубликовано 17 февраля 2026, 17:01
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 → goo.gle/developers

Speakers: Jasmyne Roberts
автотехномузыкадетское