What is the syntax for defining a CTE in a CTE?
A) WITH [CTE_outer] AS (WITH [CTE_inner] AS (SELECT * FROM table_name) SELECT * FROM [CTE_inner])
B) WITH [CTE_outer] AS (WITH [CTE_inner] AS (SELECT * FROM table_name) SELECT * FROM [CTE_inner])
C) WITH [CTE_outer] AS (WITH [CTE_inner] AS (SELECT * FROM table_name) SELECT * FROM [CTE_inner])
D) WITH [CTE_outer] AS (WITH [CTE_inner] AS (SELECT * FROM table_name) SELECT * FROM [CTE_inner])