I am trying to find the average BMI by race from patients over 20. I keep getting "0 rows affected." I have done another problem where did the same thing except it was patients over 40. I copied the existing code from that example that runs and thought it would be easy. The table name is correct. I would appreciate it you could solve as close to what my code looks like so I can understand why it's not working on this problem but worked for the other question I answered. This is in SQL. Thanks!

Table I'm referencing:

My Code:

Example Code that Worked:

way to help address this question. There are other ways though) + SELECT race , avg (average bmi) as average_bmil from \#bmi table where bmi category is not nu11 group by race order by average_bmi desc (0 rows affected) Total execution time: 00:00:00.006 null" is one way to help address this question. There are other ways though) ( 2 rows affected) Total execution time: 00:00:00.116