NB: This document was to review, understand, and outline the case that needed to be studied. Prewrite queries and fix them if there are any issues.