Sometimes it is useful to not only compute aggregated functions, but also to be able to compare them on a row by row basis with…