The analytical formula for the stagnation pressure $p_{st}$ is :
$$p_{st} = p_{\infty} + \frac{1}{2} \rho V^2$$
with $p_∞$ static pressure, $\rho$ = air density, $V$ = air speed for incompressible flow.
The point where the fluid is at rest is the point where stagnation pressure = static pressure ($p_{\infty} = p_{st}$), because the kinetic energy of the fluid is 0.
For compressible flows you can calculate the ratio of Stagnation/Static pressure with the formula :
$$\frac{p_{st}}{p_∞} = {\left( 1 + \frac{\gamma - 1}{2}M^2\right)}^{\frac{\gamma}{\gamma - 1}} $$ , simply by replacing Mach=0 then you can see that the stagnation pressure = static.
Try understanding how pitot measurement for pressure works and try studying Anderson for Fundamental Aerodynamics.
Hope that helps