Criteo interview question

Basic sql and python questions