-- What has been the avg. death rate by race? SELECT STUB_NAME, STUB_LABEL, YEAR, ESTIMATE FROM death_rates WHERE STUB_LABEL NOT LIKE '%years%' -- exclude age bracket descriptions AND STUB_NAME LIKE '%and%' -- include all categories except 'sex only'