updated ctec227_final.sql