text: create database ait;
  use ait;
  
  CREATE TABLE members (
      id INT AUTO_INCREMENT,
      name VARCHAR(100) NOT NULL,
      email VARCHAR(255),
      birthDate DATE,
      PRIMARY KEY (id)
  );
  
  CREATE TABLE reminders (
      id INT AUTO_INCREMENT,
      memberId INT,
      message VARCHAR(255) NOT NULL,
      PRIMARY KEY (id , memberId)
  );
  
  DELIMITER $$
  
  CREATE TRIGGER after_members_insert
  AFTER INSERT
  ON members FOR EACH ROW
  BEGIN
      IF NEW.birthDate IS NULL THEN
          INSERT INTO reminders(memberId, message)
          VALUES(new.id,CONCAT('Hi ', NEW.name, ', please update your date of birth.'));
      END IF;
  END$$
  
  DELIMITER ;
  
  INSERT INTO members(name, email, birthDate)
  VALUES
      ('John Doe', 'john.doe@example.com', NULL),
      ('Jane Doe', 'jane.doe@example.com','2000-01-01');
  
  select *from members;
  select *from reminders;