Pergunta de entrevista da empresa Veeva Systems

Write queries for some database requests for given schema. Interviewer provided a schema and asked to write series of sql queries. Than I was asked about different join statements. Also was given few java code examples and was asked to detect bugs in it.