Explanation:
When using subquery to insert data into the table do not use the VALUES clause and the number of columns in the INSERT clause must match to number of column in the subquery. In the above written statement STU_TYPE_ID column is in the pt_student table but is missing in the subquery select list so this will cause an error.

---