and you can use them in multiple places. I'm not sure if you have the same subquery twice if the query optimizer uses a single dataset.