Accenture interview question

1) In sql they asked about temptables,cte, sub queries