Exercise #18
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;🚫
[[ error ]]
| [[ column ]] |
|---|
| NULL [[ value ]] |