I am looking to create another column that displays the numerical value of how many non-caucasian patients visit the clinic but I cannot seem to get them to sum together. My code is giving me the feedback I want, I just can't figure out how to sum rows of patients together. My code (SQL) just lists the patients one by one. Any help is appreciated.

1. How many non-Caucasian patients have ever visited our healthcare system? (Hint: Look at cohort table) - -Please enter the code for question one here select race fromi hcan361_ha. dbo.cohort where race in ("black or african american", "asian", "hispanic", "native havailan or other pacfic islander", "other race', "american indian or slsaska native') .- I am considering 'unknown', "declined', and 'null' as white becaue there is a chance they are white. select count (*) over () as total_patients --select sum(race) - FROM - hcan361_hw.dbo. cohort - I am attempting to create a colunn that wil1 tell me the sum and not have to look at (4488 rows affected). (4252 rows affected) (1 row affected) Total execution time: 00:00:00.153