Excercise #20 | Interactive tutorial on SQL

	Common mistakes in solving SELECT statement exercises Computer Firm Database Exercise #20
	Find the makers producing at least three distinct models of PCs. Result set: maker, number of models. The beginners frequently ask: "Why the answer for this task is estimated by the system as correct that the producer E has three distinct models, whereas the query Console Execute SELECT Product.maker, PC.model FROM PC, Product WHERE Product.model=PC.model; SELECT Product.maker, PC.model FROM PC, Product WHERE Product.model=PC.model; Scheme give us only one model for this producer?" Models which are produced in principle are in the Product table. We can say that the PC table contains only the PCs available now. Join of tables restrict result set only by the models (more correctly, PC units) available in PC table. Since the exercise asks us about models but not about PCs, only the Product table is to be analysed; as a result the missing models will be found. To solve the problem on SQL-EX.RU mistakes Product PC maker

SQL Problems and solutions