Pergunta de entrevista da empresa Planit

2 questions on SQL select, one simple select from one table and other join from 2 yables on common key ?