Hail to the Victors: More questions... finally gets around to asking some more run of the mill questions.
In terms of qualifying the columns in a query, if you are doing a join with two tables, does it really matter which table you use to qulaify the recurring column with? I tried switching it up on a few exercises, and it seems to produce the same results. Is there an official rule to use for figuring out which table to point a recurring column towards? If two tables are joined, doesn't that limit the recurring column to the same set of rows anyways?
The simple answer is yes. I like the reasoning because it exposes the important principles of this endeavor.
Also, if a question asks "at least" such as "List the names of customers with credit limits of at least $10,000" shouldn't you use >= in your query vs. just the > operator?
This is obvious math reasoning, leading me to query back, “Have you found yet more errors in my worked out answers?”