Question, did you write this trigger or did someone else?
Basically, it's saying this....
For every new row that was inserted into publications....
find every book in the Books table with the same ISBN of the publication that was inserted, and increment the column in books called NumPublications
My question is, what's the context of/relationship between publications and books?