Near-Wall Turbulence And Its Modulation To The Outer Flow: From Canonical Zpg To Wind Turbine Airfoils