Pergunta de entrevista da empresa Bristol Myers Squibb

Write SQL query given 2 tables. Asked to write few standard pandas function.