Pergunta de entrevista da empresa S&P Global

Design a database...Will you use index, on what columns, why? Write queries ()complex queries with 'exists' and 'non exists' clause.