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

Estimated read time 1 min read

Post Contenthttps://www.youtube.com/shorts/hJtE-c_alKw

​ 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   Read More Google for Developers 

You May Also Like

More From Author