Confluent Interview Question

2 SQL questions and one python question. Python question involved string manipulation and casting. SQL questions used pivot and window functions.