Pergunta de entrevista da empresa San Diego Supercomputer Center

Explain inner join and outer join. Explain how to parse strings in specific pattern.