why does this query run and return the wrong result? Go!
5 713
22.7
Google Developers2.61 млн
Следующее
32 дня – 14 4971:12Популярные
17 дней – 52 7950:31
4 дня – 4 9290:30Опубликовано 23 февраля 2026, 14:00
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
Subscribe to Google for Developers → goo.gle/developers
Speakers: Jasmyne Roberts
Свежие видео
20 часов – 1061:47
6 дней – 15 7341:01:27
10 дней – 13 1300:07
14 дней – 35 1060:40
14 дней – 1274:01
15 дней – 01:06:01Случайные видео
25 дней – 8 5530:41
79 дней – 106 5971:22
83 дня – 2 3460:13
18.05.22 – 5 9197:51
05.08.14 – 44 7056:25
14 часов – 35 8141:09
20 часов – 78812:39
16 часов – 6580:23
2 дня – 4 9932:00
4 дня – 11 37522:33