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?
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? If you just used the > operator, wouldn't this factor out everyone with a credit limit of $10,000 on the nose? (i.e. ch3ex3)
Comments