Exercise #18

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 price
FROM (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;
mssql
🚫
[[ error ]]
[[ column ]]
[[ value ]]

T&S

To solve the problem on SQL-EX.RU