Write ksqlDB queries

I have created a Kafka-Stream and would like to have 3 different tables with information. I have no experience with ksqlDB and struggle with the queries. No I am looking for someone to help me. I estimate the effort to be 45 minutes for someone who has some experience.