Pregunta de entrevista de Confluent

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