We have a table employees:
id | name | department |
1 | Alice | Marketing |
2 | Bob | Sales |
3 | Charlie | Marketing |
4 | Dave | Sales |
5 | Mary | Marketing |
6 | Peter | IT |
7 | Clare | IT |
8 | Greg | Sales |
Execute the common table expression (CTE) to define the cte_marketing temporary table (with id and name as columns) to include all employees, who work in the Marketing department. And then, select all rows from that table.