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. Any help is appreciated.

Reference for column names etc:

My Code:

Example that I solved where the question is 99% similar:

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