title: How to create CTE which uses another CTE as the data to further limit?
body: <p>I have searched this question here but couldn't find it, please redirect me if we already have it on the site. </p>
  
  <p>I'm looking for a way to create CTE which uses another CTE as the data to further limit. I have a CTE which creates a report for me , but I would like to narrow this report with  another input using the existing CTE.</p>
  
  <p>I hope my question is clear.</p>