For each maker producing laptops with a hard drive capacity of 10 Gb or higher, find the speed of such laptops. Result set: maker, speed.
Here is the problem, which for the first time requires use of information in several tables: maker name is in Product table, speed and hd volume are in Laptop table.
I beg the pardon of those of my readers who are advanced SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.SQL programmers, that we are analyzing the mistakes made by the beginners, but there can be no other kinds of mistakes in the problems of this level of difficulty. The level of difficulty of the problem is indicated in "Level" column in the list of exercises. Thus we can get down to the problems of the 2-nd and the 3-rd level of difficulty.
Thus, the solution is the following:
Thereby the author of this solution claims that this query outputs 5 strings more than in the correct answer, and the query that he considers more adequate:
The mistake lies in the fact that listing of the tables through comma without indication of the method of their connection is nothing but Cartesian product, about which one can read in Chapter 5 (Item 5.6).
We agree with the opinion that the second solution is more correct. It lacks only joining of the tables. At the same time the first one is a mere attempt to fudge, limiting the output of the second «correct» solution using the models of the notebooks. It should be noted that this attempt appears to be a rather clumsy one, as, in case we have not misinterpreted the idea of the author, it was enough to write instead of the predicate