DECLARE
   NumberOfProducts     NUMBER

BEGIN
  SELECT count(*)
  INTO NumberOfProducts
  FROM products
  WHERE products.MemberID = :members.MemberID;

  IF NumberOfProducts = 0 THEN
    IF :members.salary NOT BETWEEN 10000 AND 75000 THEN
       message ('With no products, salary must be 10K-75K');
       RAISE FORM_TRIGGER_FAILURE;
    END IF;
  ELSE
    IF :members.salary NOT BETWEEN 20000 AND 85000 THEN
       message ('With products, salary must be 20K-85K');
       RAISE FORM_TRIGGER_FAILURE;
    END IF;
  END IF;
END;