Compute join counts and window ranks

You are given a fixed relational dataset. Answer every part below precisely, and for each count or output you provide, justify it. There are no bind parameters or variables; all values you need are literals in the tables shown. When a part asks for a result set, return exactly the columns named. The only result set submitted for grading is the rewritten query in Part 5; the remaining parts are discussion and analysis and should be answered in prose. Fixed data Customers…