Write For Us

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

E-Commerce Solutions SEO Solutions Marketing Solutions
54 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

ava
Published
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
Category
Project
Tags
Google, developers, pr_pr: Google for Developers;
Sign in or sign up to post comments.
Be the first to comment

Up Next