Exercise #7 page 1
Find out the models and prices for all the products (of any type) produced by maker B.
The products in the database can be of three types: PCs, laptops, and printers. The natural solution for this exercise would be union of three sets according to the type of products. This is how this exercise was solved by one of our participants:
Thereby within the main database this solution produces correct result, but within the verification database it outputs the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
That is to say, we cannot compare the individual value with the set, which is the case if the maker B manufactures more than one model of any type, which is exactly so for the verification database.