text: CREATE TABLE NotificationEmails (
    Id INT PRIMARY KEY IDENTITY,
    Recipient INT,
    Subject NVARCHAR(MAX),
    Body NVARCHAR(MAX)
  )
  
  CREATE TRIGGER CreateNewNotificationEmail ON Logs
    AFTER INSERT
  AS
    BEGIN
     INSERT INTO NotificationEmails
      VALUES (
        (SELECT AccountId
         FROM inserted),
        (CONCAT('Balance change for account: ', (SELECT AccountId
                                                 FROM inserted))),
        (CONCAT('On ', (SELECT GETDATE()
                        FROM inserted),
  					  'your balance was changed from ',
  					  (SELECT OldSum FROM inserted), 'to ', (SELECT NewSum FROM inserted), '.')))
  END