使用SELECT COUNT子查询INSERT INTO返回null

I have a table with exercises inside and for each exercise some illustrations in another table. I would like to insert illustrations and keep it ordered with a 'position' attribute. So when I add an illustration the 'position' attribute is equal to the number of illustrations for the given exercise (because position starts at 0).I have a table with exercises inside and for ea