Mala Mahadevan explains how to calculate relative risk using T-SQL:
In this post we will explore a common statistical term – Relative Risk, otherwise called Risk Factor. Relative Risk is a term that is important to understand when you are doing comparative studies of two groups that are different in some specific way. The most common usage of this is in drug testing – with one group that has been exposed to medication and one group that has not. Or , in comparison of two different medications with two groups with each exposed to a different one.
Read on for an example of a statistical formula calculation which might actually be easier in T-SQL than R.