Criteo Interview Question

Asked to create SQL queries with joins and sub queries