Among the cases dismissed by the grand jury disposition, what percentage of cases is where the subject is injured?
dismissed by the grand jury disposition refers to grand_jury_disposition = 'No Bill'; the subject is injured refers to subject_statuses = 'injured'; percentage = divide(count(incidents where subject_statuses = 'injured'), count(incidents)) where grand_jury_disposition = 'No Bill' * 100%
SELECT CAST(SUM(subject_statuses = 'Injured') AS REAL) * 100 / COUNT(case_number) FROM incidents WHERE grand_jury_disposition = 'No Bill'
CREATE TABLE incidents
(
    case_number                TEXT  not null
        primary key,
    date                       DATE          not null,
    location                   TEXT  not null,
    subject_statuses           TEXT  not null,
    subject_weapon             TEXT  not null,
    subjects                   TEXT  not null,
    subject_count              INTEGER           not null,
    officers                  TEXT not null

);
CREATE TABLE officers
(
    case_number TEXT not null,
    race        TEXT         null,
    gender      TEXT         not null,
    last_name   TEXT not null,
    first_name  TEXT null,
    full_name   TEXT not null,
    foreign key (case_number) references incidents (case_number)
);
CREATE TABLE subjects
(
    case_number TEXT not null,
    race        TEXT         not null,
    gender      TEXT         not null,
    last_name   TEXT not null,
    first_name  TEXT null,
    full_name   TEXT not null,
    foreign key (case_number) references incidents (case_number)
);
