The power of Count is that you can build up your analysis using individual CTEs. However, you may want to merge these into fewer cells by the end of your analysis, reducing the number of queries sent to your database.
In the diagram below the completed analysis on the left has 11 queries going back to my database. But now that I have my results I could compile these to fewer cells. In the example on the right I have the same outputs but with only 5 cells.
β
To do this, right-click on a downstream cell > Copy as > Copy SQL > Copy.
You will now have the compiled SQL of the cell including everything upstream of it. Pasting this into a new cell allows you to reorganise your DAG. The original cells can then be deleted, or if you would like to retain them for reference you could consider hiding them in a frame or disabling manual cell execution so that you can refer back to them without the queries refreshing.