AppStateESS/homestead

update hms_student_profiles set major = 77  where major = 75;
update hms_student_profiles set major = 201 where major = 74;
update hms_student_profiles set major = 173 where major = 73;
update hms_student_profiles set major = 171 where major = 72;
update hms_student_profiles set major = 237 where major = 71;
update hms_student_profiles set major = 176 where major = 70;
update hms_student_profiles set major = 166 where major = 69;
update hms_student_profiles set major = 165 where major = 68;
update hms_student_profiles set major = 88  where major = 67;
update hms_student_profiles set major = 103 where major = 66;
update hms_student_profiles set major = 101 where major = 65;
update hms_student_profiles set major = 157 where major = 64;
update hms_student_profiles set major = 156 where major = 63;
update hms_student_profiles set major = 155 where major = 62;
update hms_student_profiles set major = 151 where major = 61;
update hms_student_profiles set major = 145 where major = 60;
update hms_student_profiles set major = 140 where major = 59;
update hms_student_profiles set major = 137 where major = 58;
update hms_student_profiles set major = 136 where major = 57;
update hms_student_profiles set major = 135 where major = 56;
update hms_student_profiles set major = 130 where major = 55;
update hms_student_profiles set major = 126 where major = 54;
update hms_student_profiles set major = 123 where major = 53;
update hms_student_profiles set major = 121 where major = 52;
update hms_student_profiles set major = 114 where major = 51;
update hms_student_profiles set major = 113 where major = 50;
update hms_student_profiles set major = 106 where major = 49;
update hms_student_profiles set major = 105 where major = 48;
update hms_student_profiles set major = 104 where major = 47;
update hms_student_profiles set major = 99  where major = 46;
update hms_student_profiles set major = 98  where major = 45;
update hms_student_profiles set major = 94  where major = 44;
update hms_student_profiles set major = 91  where major = 43;
update hms_student_profiles set major = 89  where major = 42;
update hms_student_profiles set major = 85  where major = 41;
update hms_student_profiles set major = 85  where major = 40;
update hms_student_profiles set major = 84  where major = 39;
update hms_student_profiles set major = 83  where major = 38;
update hms_student_profiles set major = 83  where major = 37;
update hms_student_profiles set major = 82  where major = 36;
update hms_student_profiles set major = 78  where major = 35;
update hms_student_profiles set major = 81  where major = 34;
update hms_student_profiles set major = 76  where major = 33;
update hms_student_profiles set major = 71  where major = 32;
update hms_student_profiles set major = 68  where major = 31;
update hms_student_profiles set major = 102 where major = 30;
update hms_student_profiles set major = 100 where major = 29;
update hms_student_profiles set major = 133 where major = 28;
update hms_student_profiles set major = 67  where major = 27;
update hms_student_profiles set major = 65  where major = 26;
update hms_student_profiles set major = 62  where major = 25;
update hms_student_profiles set major = 60  where major = 24;
update hms_student_profiles set major = 58  where major = 23;
update hms_student_profiles set major = 55  where major = 22;
update hms_student_profiles set major = 51  where major = 21;
update hms_student_profiles set major = 49  where major = 20;
update hms_student_profiles set major = 47  where major = 19;
update hms_student_profiles set major = 46  where major = 18;
update hms_student_profiles set major = 45  where major = 17;
update hms_student_profiles set major = 44  where major = 16;
update hms_student_profiles set major = 38  where major = 15;
update hms_student_profiles set major = 39  where major = 14;
update hms_student_profiles set major = 0   where major = 13;
update hms_student_profiles set major = 35  where major = 12;
update hms_student_profiles set major = 34  where major = 11;
update hms_student_profiles set major = 26  where major = 10;
update hms_student_profiles set major = 25  where major = 9;
update hms_student_profiles set major = 21  where major = 8;
update hms_student_profiles set major = 17  where major = 7;
update hms_student_profiles set major = 16  where major = 6;
update hms_student_profiles set major = 12  where major = 5;
update hms_student_profiles set major = 11  where major = 4;
update hms_student_profiles set major = 10  where major = 3;
update hms_student_profiles set major = 7   where major = 2;
update hms_student_profiles set major = 2   where major = 1;
update hms_student_profiles set major = 1   where major = 201;
update hms_student_profiles set major = 37  where major = 237;