SELECT
      fdfdi.field_district_id_value AS district_id
    , YEAR
    , race
    , ROUND(SUM(COUNT) / inner_sum * 100 ,2) AS percent
FROM
    school_data_race_ethnicity_raw sdre
    INNER JOIN field_data_field_school_id fdfsi ON fdfsi.field_school_id_value = sdre.school_id
    INNER JOIN field_data_field_district fdfd ON fdfd.entity_id = fdfsi.entity_id
    INNER JOIN field_data_field_district_id fdfdi ON fdfd.field_district_nid = fdfdi.entity_id
    INNER JOIN
    (
        SELECT fdfdi_inner.field_district_id_value, sdre_inner.YEAR, SUM(COUNT) AS inner_sum
        FROM
            school_data_race_ethnicity_raw AS sdre_inner
            INNER JOIN field_data_field_school_id AS fdfsi_inner ON fdfsi_inner.field_school_id_value = sdre_inner.school_id
            INNER JOIN field_data_field_district AS fdfd_inner ON fdfd_inner.entity_id = fdfsi_inner.entity_id
            INNER JOIN field_data_field_district_id AS fdfdi_inner ON fdfd_inner.field_district_nid = fdfdi_inner.entity_id
        GROUP BY fdfdi_inner.field_district_id_value, sdre_inner.YEAR
    ) INNER ON
        INNER.field_district_id_value = fdfdi.field_district_id_value
        AND INNER.YEAR = sdre.YEAR
GROUP BY district_id, YEAR, race