Walmart interview question

SQL questions about CTEs and when/how to use them