Understanding Analytical Function — Percentile_cont()

Hey there, hope you are doing well.
Recently, I appeared for an online SQL test and got stuck at one of the problem. Though I knew the…