I tried declare and having clause both worked. My syntax for having which I tried yesterday was incorrect.
I am now verifying data results to ensure I am fetching products with only 1 region so I can now use query to build a report for my business partner. 🙂
Much appreciate the feedback. It's been years since I've played in data and code...am refreshing my skills again:-D