-- 2014-04-01 gakunen updates

SELECT id, last_name, date_modified, grade, grade_entrance_date, grade_entered, date_modified, date_entered, contact_status FROM contacts WHERE smsgroup='student' AND grade  IN ("00", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17") 
	AND  date_modified <='2014-04-01 00:00:00'

UPDATE contacts SET grade="general" WHERE smsgroup='student' AND grade ="17" 
	AND  date_modified <='2014-04-01 00:00:00'
UPDATE contacts SET grade=grade+1 WHERE smsgroup='student' AND grade  IN ("00", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16") 
	AND  date_modified <='2014-04-01 00:00:00'