1. Learn
    2. /
  2. Courses
    3. /
  3. Improving Query Performance in SQL Server

Exercise

Column does not exist

When using WHERE as a filter condition, it is important to think about the processing order in the query. In this exercise, you want a query that returns NBA players with average total rebounds of 12 or more per game. The following formula calculates average total rebounds from the PlayerStats table;

$$Average Total Rebounds = \dfrac{(Defensive Rebounds + Offensive Rebounds)}{Games Played}$$

The first query in Step 1 returns an error. Select Run Code to view the error. The second query, in Step 2, will give you the results you want, without error, by using a sub-query.

Note that GamesPlayed is CAST AS numeric to ensure we get decimal points in our output, as opposed to whole numbers.

Instructions 1/2

undefined XP
    1
    2
  • Try to understand what the error is telling you when you run the first query, then comment out the query block on lines 2 and 9.