Would create a stored procedure, the stored procedures using an input parameter, course number, query a course, if the course hours (classhour) and credit (credit), the same output the course all the information; If different, change course in high school and credits different course credits and school, amend the hours and credit to the same value, the value is minimum, credits and school all the information and output the course, and execute the stored procedure, query "X003" lesson, of course,