Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by Mat ( 7 years ago )
SELECT DISTINCT maker, MAX(a.price) as m_price
FROM
(
SELECT DISTINCT maker, price from PRODUCT, LAPTOP
where Laptop.model=Product.model
UNION ALL
SELECT DISTINCT maker, price from PRODUCT, PC
where PC.model=Product.model
UNION ALL
SELECT DISTINCT maker, price from PRODUCT, PRINTER
where printer.model=Product.model
) AS a
group by maker
Revise this Paste