count total & percentage in ksqldb

[Mohammed Ait Haddou]

I have a stream with an event_type field, possible values are (view, cart,
purchase).

CREATE STREAM events(event_type STRING)
WITH (KAFKA_TOPIC='events', VALUE_FORMAT='DELIMITED');

I want to count the total number of all events and the number of events for
each event_type into a single table.