Canadian Red Cross interview question

With the give data tables, there was a need to create coding script.