Pergunta de entrevista da empresa Optimove

SQL questions and a riddle. In addition, I was presented with a chart and I had to explain what could explain the behavior of the data in the chart, and tell what insights I can provide by looking at it.