Use the CREATE TABLE AS SELECT statement to create a KSQL table that contains
the results of a SELECT query from another table or stream.

CREATE TABLE AS SELECT creates a new KSQL table with a corresponding Kafka topic
and streams the result of the SELECT query as a changelog into the topic. KSQL
creates a persistent query that runs continuously until you terminate it
explicitly.

To stream the result of a SELECT query into an existing table and its
underlying topic, use the INSERT INTO statement.

The following KSQL statement creates a users_female table that contains
results from a persistent query for users that have gender set to FEMALE: