Great work, as for some of the questions above.....
O'Neill was promoted to Brigadier General and put in charge of StarGate Command at the beginning of season 8 and day-to-day command of SG-1 was passed to Carter. (the show giving RDA a easier schedule)
At the beginning of Season 9 RDA effectively stepped away from the show but not the franchise when O'Neill was reassigned to Homeworld Security, Colonel Landrey assumed control of the SGC and SG-1 was given to L.C. Cameron Mitchell.
Also for the record, the "Full" SG-1 in addition to Jack O'Neil needs Mitchell, Vala Mal Doran, & Jonas Quinn at the very least.
