Pergunta de entrevista da empresa Giant Eagle

How would you use joins, CTEs, Window functions, Date functions etc