My Question is what is the best way to learn subqueries? And why are they referred to as dynamic queries? Thanks
why go through a lot of pain and RE invent the wheel !!!!
there are lots of "you tube videos" where people explain very very nicely with data and everything
please see a link below ... for sub queries
. hope this helps
YOU COULD PRACTICE a lot .....
 that depends on the person. I prefer books / written material, for which Itzik Ben-Gans books are truly superb. If you prefer videos, there are lots out there, some taking far longer than others.
 Subquery and dynamic are not directly related, they are two different things. Perhaps you meant "correlated". A subquery can be correlated, but does not have to be.