WITH
TreData (number)
AS
(
SELECT data FROM TestData WHERE data % 3 = 0
),
OddData
AS
(
SELECT id, data FROM TestData
WHERE data % 2 <> 0
)
SELECT id, data FROM OddData 
WHERE data IN (select number from TreData)
introduces CTE
{
body
references
second CTE
name
column names
