/**************************************************************************************************
 * 6A
 *************************************************************************************************/

/* Make all 6A SDN */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SDN (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `division` = "6A";

/* 6A FBL SD-1 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD1 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (153, 152, 337, 150, 151, 149);

/* 6A FBL SD-2 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD2 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (92, 95, 247, 570, 326, 93, 94);

/* 6A FBL SD-3 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD3 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (279, 239, 387, 24, 4, 125);

/* 6A FBL SD-4 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD4 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (30, 126, 226, 6, 233, 29, 52, 55);

/* 6A FBL SD-5 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD5 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (76, 37, 38, 68, 27, 205, 111);

/* 6A FBL SD-6 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD6 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (46, 131, 48, 128, 127, 368, 372);

/* 6A FBL SD-7 */
UPDATE `school_offerings` SET `division` = "6A", `league` = "6A-SD7 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (224, 51, 72, 263, 50);


/* Find all SDN */
SELECT *  FROM `school_offerings` WHERE `school_year` = 2018 AND `activity` LIKE 'FBL' AND `division` LIKE '6A' AND `league` LIKE '%-SDN%';

/**************************************************************************************************
 * 5A
 *************************************************************************************************/

/* Make all 5A SDN */
UPDATE `school_offerings` SET `division` = "5A", `league` = "5A-SDN (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `division` = "5A";

/* 5A FBL SD-1 */
UPDATE `school_offerings` SET `division` = "5A", `league` = "5A-SD1 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (145, 144, 146, 98, 246, 249, 7, 89, 8, 79, 156, 210, 81, 123);

/* 5A FBL SD-2 */
UPDATE `school_offerings` SET `division` = "5A", `league` = "5A-SD2 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (85, 222, 227, 204, 154, 132, 257, 265, 269, 344, 260, 522);

/* 5A FBL SD-3 */
UPDATE `school_offerings` SET `division` = "5A", `league` = "5A-SD3 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (129, 121, 155, 12, 13, 202, 250, 130, 139, 172, 173);


/* Find all SDN */
SELECT *  FROM `school_offerings` WHERE `school_year` = 2018 AND `activity` LIKE 'FBL' AND `division` IN ('6A', '5A') AND `league` LIKE '%-SDN%';

/**************************************************************************************************
 * 4A
 *************************************************************************************************/

/* Make all 4A SDN */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SDN (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `division` = "4A";

/* 4A FBL SD-1 */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SD1 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (53, 209, 99, 188, 270);

/* 4A FBL SD-2 */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SD2 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (100, 26, 238, 253, 57);

/* 4A FBL SD-3 */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SD3 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (256, 177, 135, 42, 185, 244);

/* 4A FBL SD-4 */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SD4 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (232, 113, 214, 251, 65);

/* 4A FBL SD-5 */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SD5 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (245, 116, 115, 33, 178);

/* 4A FBL SD-6 */
UPDATE `school_offerings` SET `division` = "4A", `league` = "4A-SD6 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (17, 248, 252, 66, 409);


/* Find all SDN */
SELECT *  FROM `school_offerings` WHERE `school_year` = 2018 AND `activity` LIKE 'FBL' AND `division` IN ('6A', '5A', '4A') AND `league` LIKE '%-SDN%';

/**************************************************************************************************
 * 3A
 *************************************************************************************************/

/* Make all 3A SDN */
UPDATE `school_offerings` SET `division` = "3A", `league` = "3A-SDN (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `division` = "3A";

/* 3A FBL SD-1 */
UPDATE `school_offerings` SET `division` = "3A", `league` = "3A-SD1 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (231, 186, 36, 273, 54, 262, 122, 83, 103, 110, 268, 140);

/* 3A FBL SD-2 */
UPDATE `school_offerings` SET `division` = "3A", `league` = "3A-SD2 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (164, 47, 183, 63, 159, 78, 3, 165, 349, 9, 31, 34);

/* 3A FBL SD-3 */
UPDATE `school_offerings` SET `division` = "3A", `league` = "3A-SD3 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (59, 404, 136, 73, 190);


/* Find all SDN */
SELECT *  FROM `school_offerings` WHERE `school_year` = 2018 AND `activity` LIKE 'FBL' AND `division` IN ('6A', '5A', '4A', '3A') AND `league` LIKE '%-SDN%';

/**************************************************************************************************
 * 2A
 *************************************************************************************************/

/* Make all 2A SDN */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SDN (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `division` = "2A";

/* 2A FBL SD-1 */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SD1 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (117, 157, 104, 255, 207, 212, 191);

/* 2A FBL SD-2 */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SD2 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (5, 229, 106, 158, 175, 40, 264);

/* 2A FBL SD-3 */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SD3 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (133, 170, 254, 258, 261, 215);

/* 2A FBL SD-4 */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SD4 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (18, 230, 176, 49, 228);

/* 2A FBL SD-5 */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SD5 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (174, 35, 181, 197, 118);

/* 2A FBL SD-6 */
UPDATE `school_offerings` SET `division` = "2A", `league` = "2A-SD6 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (61, 162, 60, 242, 21);


/* Find all SDN */
SELECT *  FROM `school_offerings` WHERE `school_year` = 2018 AND `activity` LIKE 'FBL' AND `division` IN ('6A', '5A', '4A', '3A', '2A') AND `league` LIKE '%-SDN%';

/**************************************************************************************************
 * 1A
 *************************************************************************************************/

/* Make all 1A SDN */
UPDATE `school_offerings` SET `division` = "1A", `league` = "1A-SDN (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `division` = "1A";

/* 1A FBL SD-1 */
UPDATE `school_offerings` SET `division` = "1A", `league` = "1A-SD1 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (271, 41, 101, 80, 97, 20, 163, 44, 39, 419, 28, 138, 167);

/* 1A FBL SD-2 */
UPDATE `school_offerings` SET `division` = "1A", `league` = "1A-SD2 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (221, 223, 77, 555, 70, 137, 240, 22, 198, 169, 25, 208, 282);

/* 1A FBL SD-3 */
UPDATE `school_offerings` SET `division` = "1A", `league` = "1A-SD3 (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (236, 124, 114, 211, 199, 220, 62, 2, 11, 19, 184, 213, 105, 192, 347, 96);

/* 1A FBL SD-4 [6] */
UPDATE `school_offerings` SET `division` = "1A", `league` = "1A-SD4 [6] (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (15, 200, 64, 91, 218, 237);

/* 1A FBL SD-5 [6] */
UPDATE `school_offerings` SET `division` = "1A", `league` = "1A-SD5 [6] (2018-2021)", `is_irregular` = 1 WHERE `school_year` = 2018 AND `season` = "F" AND `activity` = "FBL" AND `school` IN (234, 32, 134, 102, 272, 67, 69, 180, 179, 243, 74, 107);


/* Find all SDN */
SELECT *  FROM `school_offerings` WHERE `school_year` = 2018 AND `activity` LIKE 'FBL' AND `division` IN ('6A', '5A', '4A', '3A', '2A', '1A') AND `league` LIKE '%-SDN%';
