text: CREATE STREAM actingevents (name VARCHAR, title VARCHAR, genre VARCHAR) 
      WITH (KAFKA_TOPIC = 'acting-events', PARTITIONS = 1, VALUE_FORMAT = 'AVRO');
  
  CREATE STREAM actingevents_drama AS 
      SELECT NAME, TITLE 
        FROM ACTINGEVENTS 
       WHERE GENRE='drama';
  
  CREATE STREAM actingevents_fantasy AS 
      SELECT NAME, TITLE 
        FROM ACTINGEVENTS 
       WHERE GENRE='fantasy';
  
  CREATE STREAM actingevents_other AS 
      SELECT NAME, TITLE, GENRE
        FROM ACTINGEVENTS 
       WHERE GENRE != 'drama' 
         AND GENRE != 'fantasy';
             
  