Pergunta de entrevista da empresa CRISIL

How to select sales from yesterday using SQL? What is join, what types of joins are there? What is their difference?