Giant Eagle interview question

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