Find the makers of the cheapest color printers. Result set: maker, price.
Find two mistakes in the following solution to this task:
SELECT c.maker, a.priceA priceFROM (SELECT MIN(price) priceA FROM Printer WHERE color ='y' ) a INNER JOIN Printer b ON a.priceA = b.price INNER JOIN Product c ON b.model = c.model;
T&S
To solve the problem on SQL-EX.RU
go
Console
Execute
